Re: Bulk_insert in postgresql like Microsoft SQL server

Поиск
Список
Период
Сортировка
От Devendra Yadav
Тема Re: Bulk_insert in postgresql like Microsoft SQL server
Дата
Msg-id CAE+tJY8YF8sJXiqvH8yWLNepi2BTf-pLouO7VyycrOXJsLqpgA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Bulk_insert in postgresql like Microsoft SQL server  (Shreeyansh Dba <shreeyansh2014@gmail.com>)
Ответы Re: Bulk_insert in postgresql like Microsoft SQL server
Список 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@gmail.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.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 по дате отправления:

Предыдущее
От: SBob
Дата:
Сообщение: Re: Bulk_insert in postgresql like Microsoft SQL server
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: Bulk_insert in postgresql like Microsoft SQL server