Re: Load or Copy ??

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Patrik Kudo <kudo(at)partitur(dot)se>
Cc: Sebastian <hallogammler(at)aol(dot)com>, pgsql-sql(at)postgresql(dot)org
Subject: Re: Load or Copy ??
Date: 2001-02-07 15:43:25
Message-ID: 28324.981560605@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Patrik Kudo <kudo(at)partitur(dot)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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2001-02-07 15:48:21 Re: [SQL] Re: SQL Join - MySQL/PostgreSQL difference?
Previous Message Brice Ruth 2001-02-07 15:26:23 Re: [SQL] Re: SQL Join - MySQL/PostgreSQL difference?