Re: Insert (large sql file)

[Dave Page <dpage(at)postgresql(dot)org>]

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.