Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Populate records from csv file

Status
Not open for further replies.
tanveer91

tanveer91

Programmer
Nov 13, 2001
31
GB
Hi all,

i'm new to PostgreSQL. I would like to know how you can populate a postgres Database from records taken from a csv file??

Thank you
 
Sort by date Sort by votes
HI,

Take a look at the postgres copy command. It allow for a CVS file to be copies into a postgres Database.
Leland F. Jackson, CPA
Software - Master (TM)
Nothing Runs Like the Fox
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

MCP2000
  • Locked
  • Question
Show records NOT BETWEEN date/timestamps
Replies
2
Views
193
MCP2000
MCP2000
beakerboy
  • Locked
  • Question
Query from tables sharing primary keys
Replies
0
Views
96
beakerboy
beakerboy
mlgmartin
  • Locked
  • Question
How to free up disk space from Smoothwall's /var/log folder?
Replies
0
Views
122
mlgmartin
mlgmartin
ca8msm
  • Locked
  • Question
Copy Database from Linux to Windows 1
Replies
3
Views
164
stefanwagner
stefanwagner
andnos
  • Locked
  • Question
export into csv
Replies
4
Views
59
postgresql007
postgresql007

Part and Inventory Search

Sponsor

Back
Top