You can't because the backend opens that file as the super-user. You can use \copy in psql as an normal user, though.
--------------------------------------------------------------------------- Jaume Teixi wrote: > how should I use " COPY arti FROM 'ARTI.txt' USING DELIMITERS '|' " as normal user ? > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html > -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
