Re: Insert (large sql file) - Mailing list 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.