Re: How to load data in psql DB

[Ashwani Kumar B <ashwani.b.kumar@xxxxxxxxxxxx>]

Hi

 

It will be helpful if you share  any sample script which works in crontab and also sample of control file.

 

Regards

Ashwani

 

From: pgsql-admin-owner@xxxxxxxxxxxxxx [mailto:pgsql-admin-owner@xxxxxxxxxxxxxx] On Behalf Of Arnaud Gambonnet
Sent: Wednesday, May 31, 2017 1:03 PM
To: pgsql-admin@xxxxxxxxxxxxxx
Subject: Re: [ADMIN] How to load data in psql DB

 

Hi,

 

pgloader should fit your need.

 

=> http://pgloader.io

 

Regards,

AG.

 

2017-05-31 8:30 GMT+02:00 Ashwani Kumar B <ashwani.b.kumar@xxxxxxxxxxxx>:

Hi

 

My requirement is to automatically load data which is in CSV format to psql DB table.

 

Normally in oracle I use to do it through sql-loader [sqlldr] . Do we have anything similar in psql.

 

Regards

Ashwani