Received: from gatekeeper2.embratel.com.br ([200.255.122.2])
	by hub.org (8.9.3/8.9.3) with ESMTP id TAA63250
	for <pgsql-interfaces@hub.org>; Wed, 18 Aug 1999 19:53:54 -0400 (EDT)
	(envelope-from rodneyr@embratel.com.br)
From: rodneyr@embratel.com.br
Received: by gatekeeper2.embratel.com.br; (8.8.8/1.3/10May95) id UAA05992;
	Wed, 18 Aug 1999 20:57:42 -0300 (EST)
Received: from somewhere by smtpxd
Received: from somewhere by smtpxd
X-Lotus-FromDomain: EMBRATEL
To: pgsql-interfaces@hub.org
Message-ID: <032567D1.008359C1.00@ntrjo008.nt.embratel.com.br>
Date: Wed, 18 Aug 1999 20:54:50 -0300
Subject: Inserting data into PostgreSQL
Mime-Version: 1.0
Content-type: text/plain; charset=us-ascii
Content-Disposition: inline

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.