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@postgresql.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?


Reply via email to