Skip site navigation (1) Skip section navigation (2)

How to read from a text file and populate the table

From: "Somasekhar Bangalore" <sbangalore(at)zensutra(dot)com>
To: "Ashvinder Singh" <ashvindersingh(at)hfcl(dot)com>,<pgsql-admin(at)postgresql(dot)org>
Subject: How to read from a text file and populate the table
Date: 2004-09-27 07:02:46
Message-ID: BF493B193A334743AA9EF48945E69C13A24475@exchange.india.zensutra.com (view raw or flat)
Thread:
Lists: pgsql-admin
Hi All,
 
I need your advice help . like sqlloader in oracle. I have to read data from a text file and populate the tables. Can anyone of you send me the code to read the sample data and populate multiple tables at the same time.
 
Thanks in advance
Som

pgsql-admin by date

Next:From: Somasekhar BangaloreDate: 2004-09-27 09:09:44
Subject: how to read /write xml data and insert into the postgres database
Previous:From: Michael FuhrDate: 2004-09-26 11:26:11
Subject: Re: pg_dump trouble

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group