Thread: [ADMIN] How to load data in psql DB
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
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
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@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Arnaud Gambonnet
Sent: Wednesday, May 31, 2017 1:03 PM
To: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] How to load data in psql DB
2017-05-31 8:30 GMT+02:00 Ashwani Kumar B <ashwani.b.kumar@ericsson.com>:
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
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@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Arnaud Gambonnet
Sent: Wednesday, May 31, 2017 1:03 PM
To: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] How to load data in psql DB
2017-05-31 8:30 GMT+02:00 Ashwani Kumar B <ashwani.b.kumar@ericsson.com>:
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