Re: [HACKERS] COPY as non super user

2003-02-02 Thread Bruce Momjian

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



[HACKERS] COPY as non super user

2003-01-31 Thread Jaume Teixi
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