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

From: Richard Broersma Jr <rabroersma(at)yahoo(dot)com>
To: Jorge Alberto <csnmgeek(at)gmail(dot)com>, Sean Davis <sdavis2(at)mail(dot)nih(dot)gov>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: ERROR: must be superuser to COPY to or from a file
Date: 2007-09-28 20:26:55
Message-ID: 231234.31398.qm@web31801.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice


--- Jorge Alberto <csnmgeek(at)gmail(dot)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.

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2007-09-28 21:08:16 Re: Why is my view ddl being altered by postgres?
Previous Message Jorge Alberto 2007-09-28 20:09:54 Re: ERROR: must be superuser to COPY to or from a file