Stored Procedure: Copy table from; path = text variable - Mailing list pgsql-general

From Charles Pare
Subject Stored Procedure: Copy table from; path = text variable
Date
Msg-id BAY124-W186331C42248ED7DADA894EF0C0@phx.gbl
Whole thread Raw
Responses Re: Stored Procedure: Copy table from; path = text variable  (Richard Huxton <dev@archonet.com>)
List pgsql-general
Hi, in a stored procedure, if I do
COPY table FROM 'mypath' DELIMITERS '\t'; it works but if my path is a text variable which contain my path, 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

Is there any workaround? I want to create a temporary table, copy from and parse the table, all with dynamic path depending of how the function is called.

Thank's
Charles


Explore the seven wonders of the world Learn more!

pgsql-general by date:

Previous
From: Emi Lu
Date:
Subject: Date for a week day of a month
Next
From: Richard Huxton
Date:
Subject: Re: Stored Procedure: Copy table from; path = text variable