COPY with a variable path - Mailing list pgsql-general

From Bill Todd
Subject COPY with a variable path
Date
Msg-id 492F0898.6080508@dbginc.com
Whole thread Raw
Responses Re: COPY with a variable path
List pgsql-general
I want to execute the following COPY command in a stored procedure,
however, I need to pass the path to the file as an input parameter.
Substituting the input parameter for the literal path does not work and
neither does using PREPARE/EXECUTE. How can I pass the file path as a
parameter?

  copy contact.palm_import from 'c:/_junk/palm.csv'
  with delimiter as ','
  null as ''
  csv quote as '"';

Thanks,

Bill

pgsql-general by date:

Previous
From: "Andrus"
Date:
Subject: Expected password response, got message type 88
Next
From: Raymond O'Donnell
Date:
Subject: Re: COPY with a variable path