Postgres Pro
Downloads
Home   >   mailing lists

Re: Bulk_insert in postgresql like Microsoft SQL server - Mailing list pgsql-admin

From Shreeyansh Dba
Subject Re: Bulk_insert in postgresql like Microsoft SQL server
Date
Msg-id CAGDYbUM+=i2j1ZQk2ohaBF8kQ=yB1FkyDM=su2T_wE5kT8nu5w@mail.gmail.com
Whole thread Raw
In response to Bulk_insert in postgresql like Microsoft SQL server  (Devendra Yadav <devendra.857@gmail.com>)
Responses Re: Bulk_insert in postgresql like Microsoft SQL server  (SBob <sbob@quadratum-braccas.com>)
Re: Bulk_insert in postgresql like Microsoft SQL server  (Devendra Yadav <devendra.857@gmail.com>)
List pgsql-admin
Tree view

Hi Devendra,

You can use copy command for Bulk Insert in PostgreSQL.

On Wed, Dec 19, 2018 at 10:59 PM Devendra Yadav <devendra.857@gmail.com> wrote:
Dear all,

We need to provide copy rights to our developer's for bulk inserts. But the case is that, for it to happen it needs superuser permission which is very expensive thing a DBA can grant. 
Can anybody please suggest if there are such tools or utility through which this can be achieved and with minimal rights.

Thanks and Regards,
Devendra Yadav

pgsql-admin by date:

Previous
From: Devendra Yadav
Date:
Subject: Bulk_insert in postgresql like Microsoft SQL server
Next
From: SBob
Date:
Subject: Re: Bulk_insert in postgresql like Microsoft SQL server