On Mon, 4 Feb 2008 17:21:00 +0100
"Pau Marc Munoz Torres" <[EMAIL PROTECTED]> 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 simil
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?
Thanks
Pau
2008/2/4
Hi,
Le lundi 04 février 2008, Pau Marc Munoz Torres a écrit :
> I'm an ex-mysql user, i know there was a sentence in mysql that was
>
> load data local infile "somefile.txt" into table "sometable;
>
> I'm trying to do something similar in postgresql, can someone help me?
COPY manual entry
On Mon, 4 Feb 2008 16:29:51 +0100
"Pau Marc Munoz Torres" <[EMAIL PROTECTED]> wrote:
> Hi
>
> I'm an ex-mysql user, i know there was a sentence in mysql that was
>
> load data local infile "somefile.txt" into table "sometable;
>
> I'm trying to do something similar in postgresql, can som
On 04/02/2008 15:29, Pau Marc Munoz Torres wrote:
I'm trying to do something similar in postgresql, can someone help me?
You're probably looking for the COPY command:
http://www.postgresql.org/docs/8.3/static/sql-copy.html
Ray.
Hi
I'm an ex-mysql user, i know there was a sentence in mysql that was
load data local infile "somefile.txt" into table "sometable;
I'm trying to do something similar in postgresql, can someone help me?
Thanks
Pau
--
Pau Marc Muñoz Torres
Laboratori de Biologia Computacional
Institut
