Search Postgresql Archives

Re: loading files into tables

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Mon, 4 Feb 2008 17:21:00 +0100
"Pau Marc Munoz Torres" <paumarc@xxxxxxxxx> wrote:

> Ok
> 
>  I'm tryint to execute
> 
>      copy local from "/path" with delimiter "\t";
> 
> and I get the following errors
> 
>   ERROR: must be superuser to COPY to or from a file.
> 
>  Can I do something similar to it without being superuser?
> 
>  for a Tab delimiter, should i use "\t" character?

The message should be longer and actually explain what to do.

you can \copy or copy from stdin.

You could find this helpful:

http://www.postgresql.org/docs/techdocs.15

-- 
Ivan Sergio Borgonovo
http://www.webthatworks.it


---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux