Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Fri, 28 Sep 2007 13:26:55 -0700 (PDT)
--- 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.
- References:
- Re: ERROR: must be superuser to COPY to or from a file
- From: Jorge Alberto
- Re: ERROR: must be superuser to COPY to or from a file
- Prev by Date: Re: ERROR: must be superuser to COPY to or from a file
- Next by Date: Re: Why is my view ddl being altered by postgres?
- Previous by thread: Re: ERROR: must be superuser to COPY to or from a file
- Next by thread: Re: ERROR: must be superuser to COPY to or from a file
- Indexes: