Re: [NOVICE] ERROR: must be superuser to COPY to or from a file

From: Richard Broersma Jr <rabroersma(at)yahoo.com>
Date: Fri Sep 28 2007 - 16:26:55 EDT

• Jorge Alberto <csnmgeek@gmail.com> wrote:

> correct syntax:
> mydb=> \copy weather FROM /home/fideito/weather.txt
>
> I have to delete the "" and the ";" to make it work.
> Do you know why is that?

my guess is that \copy is a psql command not a PostgreSQL command.

So \copy has different rules than than the syntax that PostgreSQL directly interprets.

Regards,
Richard Broersma Jr.

---------------------------(end of broadcast)---------------------------

TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq Received on Fri Sep 28 16:29:33 2007