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

Re: [INTERFACES] Inserting data into PostgreSQL

From: SUMA R <suma(dot)r(at)tatainfotech(dot)com>
To: rodneyr(at)embratel(dot)com(dot)br
Cc: pgsql-interfaces(at)hub(dot)org
Subject: Re: [INTERFACES] Inserting data into PostgreSQL
Date: 1999-08-19 01:41:18
Message-ID: Pine.LNX.4.04.9908190708210.31411-100000@blrmail.in.tatainfotech.com (view raw or flat)
Thread:
Lists: pgsql-interfaces
Hi,
   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?
> 
> Thanks,
> 
> Rodney.
> 
> 
> 
> ************
> Check out "PostgreSQL Wearables" @ http://www.pgsql.com
> 


In response to

Responses

pgsql-interfaces by date

Next:From: pplegalDate: 1999-08-19 04:35:14
Subject: BE THE FIRST IN YOUR AREA WITH NEW PERSONAL POSTCARDS!
Previous:From: rodneyrDate: 1999-08-18 23:54:50
Subject: Inserting data into PostgreSQL

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