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?