Inserting data into PostgreSQL - Mailing list pgsql-interfaces

From rodneyr@embratel.com.br
Subject Inserting data into PostgreSQL
Date
Msg-id 032567D1.008359C1.00@ntrjo008.nt.embratel.com.br
Whole thread Raw
Responses Re: [INTERFACES] Inserting data into PostgreSQL  (SUMA R <suma.r@tatainfotech.com>)
List pgsql-interfaces
How can I inserting data from a file into PostgreSQL? I've tried the
following SQL command, but it didn't work:

INSERTO INTO table_name (column_name[, ...])  FROM FILE 'file_name' (data_type, ...)

I received the message:

ERROR:  parser: parse error at or near "from"

Besides, which caracter must we use to separate the columns into the file?
I used ",". Is it correct?

Thanks,

Rodney.




pgsql-interfaces by date:

Previous
From: "carlos callo lazo"
Date:
Subject: How to notify Front Ends of Table Changes
Next
From: SUMA R
Date:
Subject: Re: [INTERFACES] Inserting data into PostgreSQL