| From: | SBob <sbob(at)quadratum-braccas(dot)com> |
|---|---|
| To: | pgsql-admin(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Bulk_insert in postgresql like Microsoft SQL server |
| Date: | 2018-12-19 17:45:19 |
| Message-ID: | d997e599-9318-fcfc-aca3-c73fb66c2a17@quadratum-braccas.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Use the \copy command instead of the COPY command
https://www.postgresql.org/docs/11/app-psql.html
On 12/19/18 10:40 AM, Shreeyansh Dba wrote:
>
> Hi Devendra,
>
> You can use copy command for Bulk Insert in PostgreSQL.
>
> On Wed, Dec 19, 2018 at 10:59 PM Devendra Yadav
> <devendra(dot)857(at)gmail(dot)com <mailto:devendra(dot)857(at)gmail(dot)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
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Devendra Yadav | 2018-12-19 17:45:56 | Re: Bulk_insert in postgresql like Microsoft SQL server |
| Previous Message | Shreeyansh Dba | 2018-12-19 17:40:27 | Re: Bulk_insert in postgresql like Microsoft SQL server |