On Tue, Jan 6, 2009 at 11:41 AM, Pedro Doria Meunier <pdo...@netmadeira.com> wrote: > Hi All, > > This is a bit embarassing ... but ... > > I have a partial set of data that I want to restore via COPY ... FROM command > > I have created a public folder for the effect and chown'ed both the folder and > the file to be fed into COPY to a+rw ... > > I switched users with su - postgres and connected to the DB with the psql > command > > All I'm getting is a Permission denied upon issuing the COPY command from > within psql interactive terminal! :O
What is the exact error you're getting? It's better to usually use copy from stdin which has none of these problems. It's the same syntax tat pg_dump uses when it creates a backup. For example: COPY b (a_i, b) FROM stdin; 1 moreabc \. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
