Thread: Load or Copy ??

Hi

What is wrong?

$result = pg_Exec($db,"COPY forum FROM {'datei.csv' | stdin} USING
DELIMITERS '|';");

I will load datei.csv into forum!

This is for MySQL:

$result = pg_Exec($db,"LOAD DATA INFILE 'datei.csv' INTO TABLE forum FIELDS
TERMINATED BY '|' LINES TERMINATED BY '\n'");

And for PostgreSQL:
????????????????????

Regards, Sebastian

Hi

try

COPY forum FROM 'datei.csv' USING DELIMITERS '|';

You should use either 'filename' OR stdin, not both.

Hope it helps.

Regards,
Patrik Kudo

--
ech`echo xiun|tr nu oc|sed 'sx\([sx]\)\([xoi]\)xo un\2\1 is xg'`ol
Känns det oklart? Fråga på!

On Tue, 6 Feb 2001, Sebastian wrote:

> Hi
>
> What is wrong?
>
> $result = pg_Exec($db,"COPY forum FROM {'datei.csv' | stdin} USING
> DELIMITERS '|';");
>
> I will load datei.csv into forum!
>
> This is for MySQL:
>
> $result = pg_Exec($db,"LOAD DATA INFILE 'datei.csv' INTO TABLE forum FIELDS
> TERMINATED BY '|' LINES TERMINATED BY '\n'");
>
> And for PostgreSQL:
> ????????????????????
>
> Regards, Sebastian
>
>
>
>

Patrik Kudo <kudo@partitur.se> writes:
> COPY forum FROM 'datei.csv' USING DELIMITERS '|';
> You should use either 'filename' OR stdin, not both.

Check.  You'll probably also find that you need to supply an absolute
pathname, since the backend is not running in the same directory that
your client is in.
        regards, tom lane