Re: Load or Copy ?? - Mailing list pgsql-sql

From Patrik Kudo
Subject Re: Load or Copy ??
Date
Msg-id Pine.BSF.4.31.0102071614410.90380-100000@tb303.partitur.se
Whole thread Raw
In response to Load or Copy ??  ("Sebastian" <hallogammler@aol.com>)
Responses Re: Load or Copy ??  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
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
>
>
>
>



pgsql-sql by date:

Previous
From: Brice Ruth
Date:
Subject: Re: SQL Join - MySQL/PostgreSQL difference?
Next
From: Brice Ruth
Date:
Subject: Re: Re: SQL Join - MySQL/PostgreSQL difference?