Search Postgresql Archives

Stored Procedure: COPY table FROM (where path is a text variable)

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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 mytextvar DELIMITERS '\t'; it doesn't work, I get

ERROR: syntax error at or near "$1"
SQL state: 42601
Context: SQL statement in PL/PgSQL function "parseinsert" near line 15

Thank's
Charles


Get news, entertainment and everything you care about at Live.com. Check it out!

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux