Restore PLAIN file

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Restore PLAIN file

Tan Chen Yee
Hi,

I have backup a database in plain text format. I know I cannot use pgadmin
III to restore it.
What is other way to do the restoration ?

Thanks !

TAn


---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
Reply | Threaded
Open this post in threaded view
|

Re: Restore PLAIN file

Richard Huxton
Tan Chen Yee wrote:
> Hi,
>
> I have backup a database in plain text format. I know I cannot use pgadmin
> III to restore it.
> What is other way to do the restoration ?

psql -f my_file ...

--
   Richard Huxton
   Archonet Ltd

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq