Re: How to load data in psql DB

From: Ashwani Kumar B <ashwani(dot)b(dot)kumar(at)ericsson(dot)com>
To: Arnaud Gambonnet <arnaud(dot)gambonnet(at)gmail(dot)com>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: How to load data in psql DB
Date: 2017-05-31 07:55:26
Message-ID: AM3PR07MB35489CAE9D57C1CB92E07F5C0F10@AM3PR07MB354.eurprd07.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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(at)postgresql(dot)org [mailto:pgsql-admin-owner(at)postgresql(dot)org] On Behalf Of Arnaud Gambonnet
Sent: Wednesday, May 31, 2017 1:03 PM
To: pgsql-admin(at)postgresql(dot)org
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(dot)b(dot)kumar(at)ericsson(dot)com<mailto:ashwani(dot)b(dot)kumar(at)ericsson(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Samed YILDIRIM 2017-05-31 10:13:19 Re: How to load data in psql DB
Previous Message Arnaud Gambonnet 2017-05-31 07:33:20 Re: How to load data in psql DB