U can insert the data from a file to the table using the copy command
COPY table_name FROM 'filename' USING DELIMITERS 'del'
Better u give absolute pate when referring to the filename.
On Wed, 18 Aug 1999 rodneyr(at)embratel(dot)com(dot)br wrote:
> 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?
> Check out "PostgreSQL Wearables" @ http://www.pgsql.com
In response to
pgsql-interfaces by date
|Next:||From: pplegal||Date: 1999-08-19 04:35:14|
|Subject: BE THE FIRST IN YOUR AREA WITH NEW PERSONAL POSTCARDS!|
|Previous:||From: rodneyr||Date: 1999-08-18 23:54:50|
|Subject: Inserting data into PostgreSQL|