Skip site navigation (1) Skip section navigation (2)

Inserting data into PostgreSQL

From: rodneyr(at)embratel(dot)com(dot)br
To: pgsql-interfaces(at)hub(dot)org
Subject: Inserting data into PostgreSQL
Date: 1999-08-18 23:54:50
Message-ID: 032567D1.008359C1.00@ntrjo008.nt.embratel.com.br (view raw or flat)
Thread:
Lists: 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.



Responses

pgsql-interfaces by date

Next:From: SUMA RDate: 1999-08-19 01:41:18
Subject: Re: [INTERFACES] Inserting data into PostgreSQL
Previous:From: Geocrawler.comDate: 1999-08-18 18:23:47
Subject: Error with Perl interface

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group