Stored Procedure: COPY table FROM (where path is a text variable)
This is a discussion on Stored Procedure: COPY table FROM (where path is a text variable) within the Pgsql General forums, part of the PostgreSQL category; --> Hi, in a stored procedure, if I do COPY table FROM 'mypath' DELIMITERS '\t'; it works but if my ...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-09-2008, 06:14 PM
| ||||
| ||||
 Stored Procedure: COPY table FROM (where path is a text variable) Hi, in a stored procedure, if I do COPY table FROM 'mypath' DELIMITERS '\t'; it works but if my path is a text variable, i.e.COPY table FROM mytextvarDELIMITERS '\t'; it doesn't work, I get ERROR: syntax error at or near "$1"SQL state: 42601Context: SQL statement in PL/PgSQL function "parseinsert" near line 15Thank'sCharles __________________________________________________ _______________ News, entertainment and everything you care about at Live.com. Get it now! http://www.live.com/getstarted.aspx      |
Linear Mode
