From: | Patrik Kudo <kudo(at)partitur(dot)se> |
---|---|
To: | Sebastian <hallogammler(at)aol(dot)com> |
Cc: | <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: Load or Copy ?? |
Date: | 2001-02-07 15:18:15 |
Message-ID: | Pine.BSF.4.31.0102071614410.90380-100000@tb303.partitur.se |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
>
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Brice Ruth | 2001-02-07 15:26:23 | Re: [SQL] Re: SQL Join - MySQL/PostgreSQL difference? |
Previous Message | Brice Ruth | 2001-02-07 15:13:45 | Re: SQL Join - MySQL/PostgreSQL difference? |