| From: | Dave Page <dpage(at)postgresql(dot)org> |
|---|---|
| To: | "Ezequias R(dot) da Rocha" <ezequias(at)fastcon(dot)com(dot)br> |
| Cc: | pgadmin-support(at)postgresql(dot)org |
| Subject: | Re: Insert (large sql file) |
| Date: | 2007-03-23 13:15:38 |
| Message-ID: | 4603D2FA.8090409@postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mike.Blackwell | 2007-03-23 17:52:19 | adminpack install |
| Previous Message | Ezequias R. da Rocha | 2007-03-23 12:39:23 | Insert (large sql file) |