Forum OpenACS Q&A: Any utility that is similer to SQL Loader in PGSQL

Collapse
1: Any utility that is similer to SQL Loader in PGSQL
Posted by Gautam Kumar on 09/04/06 07:28 AM
Hi!,
I want to load the data from flat file. Is any utility in PGSQL which is similar to SQL Loader utility of Oracle?
Actually I want to load the n number of files which is comma separated. And we also required a log which says that how many data has been loaded and how many data not loaded. If not loaded then what was the reason behind this.
Please help............!

Regards,

Gautam

Collapse
2: Re: Any utility that is similer to SQL Loader in PGSQL (response to 1)
Posted by Ashwin Kumar on 09/04/06 08:55 PM
Hi goutam,

Just check out how package ref-us-countries does that

"packages/ref-us-counties/sql/postgresql/00-us-counties.ctl"
"packages/ref-us-counties/sql/common/us-counties.dat"


Regards,
Ashwin