| From: | Beena J P <beena(dot)jp(at)nic(dot)in> |
|---|---|
| To: | Mike angelo <angelocmp(at)yahoo(dot)com>, pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: CSV Utility |
| Date: | 2009-08-07 05:11:46 |
| Message-ID: | 003b01ca171d$8fe991e0$3702a20a@Beena |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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: Mike angelo
To: pgsql-admin(at)postgresql(dot)org
Sent: Friday, August 07, 2009 2:57 AM
Subject: [ADMIN] CSV Utility
Is there a Postgres utility that allows data contained in a CSV file to be loaded into the database?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Beena J P | 2009-08-07 05:12:15 | Re: CSV Utility |
| Previous Message | Lennin Caro | 2009-08-06 22:05:59 | Re: Change stored procedures schema name |