Обсуждение: Insert (large sql file)

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

Regards...

-- 
Atenciosamente
Ezequias Rodrigues da Rocha

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.