Re: Insert (large sql file)

Поиск
Список
Период
Сортировка
От Dave Page
Тема Re: Insert (large sql file)
Дата
Msg-id 4603D2FA.8090409@postgresql.org
обсуждение исходный текст
Ответ на Insert (large sql file)  ("Ezequias R. da Rocha" <ezequias@fastcon.com.br>)
Список pgadmin-support
Ezequias R. da Rocha wrote:
> Hi list,
> 
> I would like to know if it is possible to load a large insert statement 
> (.sql file) without need to open it in the Query Tool on pgAdmin.
> 
> I am waitting for more than 30 minuts to load it on wordpad to copy 
> small ammounts of this insert.
> 
> My sql file has 171 Mb size.
> 
> ps:  I have no access to my server terminal.
> ps2: I must change all the inserts adding the schema before the name of 
> the table
> ps3: I am in Windows

Use psql not pgAdmin. Syntax highlighting a file that large would take 
forever, even once it has loaded.

Regards, Dave.


В списке pgadmin-support по дате отправления:

Предыдущее
От: "Ezequias R. da Rocha"
Дата:
Сообщение: Insert (large sql file)
Следующее
От: Mike.Blackwell@rrd.com
Дата:
Сообщение: adminpack install