At 03:20 AM 3/5/2008, [EMAIL PROTECTED] wrote:
Date: Wed, 5 Mar 2008 01:51:19 +0300
From: "Yura Gal" <[EMAIL PROTECTED]>
To: pgsql-sql@postgresql.org
Subject: using copy from in function
Message-ID:
<[EMAIL PROTECTED]>
I'm trying to automate import data using CORY FROM. For this purpose I
wrot
2008/3/4, Yura Gal <[EMAIL PROTECTED]>:
> I'm trying to automate import data using CORY FROM. For this purpose I
> wrote plpgsql function. As my postgres works on windows vista I need
> to use E'' syntax for path-to-file. This syntax works fine in SQL
> queries like:
> COPY table FROM E'path_to
I'm trying to automate import data using CORY FROM. For this purpose I
wrote plpgsql function. As my postgres works on windows vista I need
to use E'' syntax for path-to-file. This syntax works fine in SQL
queries like:
COPY table FROM E'path_to_file_with_double_backslashes';
Following query works