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 -----
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?