From: | Devendra Yadav <devendra(dot)857(at)gmail(dot)com> |
---|---|
To: | Shreeyansh Dba <shreeyansh2014(at)gmail(dot)com> |
Cc: | pgsql-admin(at)lists(dot)postgresql(dot)org |
Subject: | Re: Bulk_insert in postgresql like Microsoft SQL server |
Date: | 2018-12-19 17:45:56 |
Message-ID: | CAE+tJY8YF8sJXiqvH8yWLNepi2BTf-pLouO7VyycrOXJsLqpgA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hello Shreeyansh,
You're talking Copy command in psql utility or in pgadmin. In pgadmin it
needs superuser rights. Have not tried it from windows cmd, as the
application server is on windows.
Thanks,
Devendra Yadav
On Wed, Dec 19, 2018, 11:12 PM Shreeyansh Dba <shreeyansh2014(at)gmail(dot)com
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>
> 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 | David G. Johnston | 2018-12-19 17:47:39 | Re: Bulk_insert in postgresql like Microsoft SQL server |
Previous Message | SBob | 2018-12-19 17:45:19 | Re: Bulk_insert in postgresql like Microsoft SQL server |