Hi,
You can also use 'psql dbname < mydb.txt', the empty database should be created first using
'createdb dbname'.
--
Regards,
Riki
--- Reshat Sabiq <sabiq@purdue.edu> wrote:
>
> Don Patou wrote:
>
> >I've just pg_dump my database in a mydb.txt file. How can I use this file to
> >recreate all my tables on another computer (linux box)?
> >
> >thanx in advance
> >
> >
> >---------------------------(end of broadcast)---------------------------
> >TIP 3: if posting/reading through Usenet, please send an appropriate
> > subscribe-nomail command to majordomo@postgresql.org so that your
> > message can get through to the mailing list cleanly
> >
> >
> >
> \i mydb.txt
> There is also pg_restore.
>
> HTH.
>
> --
> Sincerely,
> Reshat.
>
> -------------------------------------------------------------------------------------------
> If you see my certificate with this message, you should be able to send me encrypted e-mail.
> Please consult your e-mail client for details if you would like to do that.
>
>
>
> ATTACHMENT part 2 application/x-pkcs7-signature name=smime.p7s
__________________________________
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com