Re: CSV Utility

[Beena J P <beena.jp@xxxxxx>]

Command to import data from text file to postgresql table
1. Create  table of the same order os text file. Then execute the command at 
Query analyser.

copy tablename  from textname (with path) CSV
eg: copy friends.office1 from 'C:/FRIENDS/ksebsouth.txt' CSV

regards
Beena
----- Original Message ----- 
From: "Steve Crawford" <scrawford@xxxxxxxxxxxxxxxxxxxx>
To: "Mike angelo" <angelocmp@xxxxxxxxx>
Cc: <pgsql-admin@xxxxxxxxxxxxxx>
Sent: Friday, August 07, 2009 3:10 AM
Subject: Re:  CSV Utility


> Mike angelo wrote:
> > Is there a Postgres utility that allows data contained in a CSV file to 
> > be loaded into the database?
> You mean like psql?
>
> \copy tablename from csvfilename CSV
>
> or with a header:
> \copy tablename from csvfilename CSV HEADER
>
> or an alternate delimiter:
> \copy tablename from csvfilename CSV delimiter '|'
>
> or export data (tab-delimited):
> copy foo to stdout CSV DELIMITER E'\t';
>
> Cheers,
> Steve
>
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin 


--
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin