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.
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
