Re: CSV Utility

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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: CSV Utility

Is there a Postgres utility that allows data contained in a CSV file to be loaded into the database?


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux