Re: Bulk_insert in postgresql like Microsoft SQL server

Yes, copy command required superuser privileges. In pgadmin, you can use
\copy (use psql console pgadminIII) or Import/Export option for bulk insert.

Thanks & Regards,
*Shreeyansh DBA Team*
www.shreeyansh.com

On Wed, Dec 19, 2018 at 11:16 PM Devendra Yadav <devendra(dot)857(at)gmail(dot)com>
wrote:

> 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
>>>
>>