From: | Riki Kurniawan <riki_kurniawan(at)yahoo(dot)com> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: using a dumped database file |
Date: | 2003-06-17 11:22:52 |
Message-ID: | 20030617112252.24559.qmail@web40513.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Hi,
You can also use 'psql dbname < mydb.txt', the empty database should be created first using
'createdb dbname'.
--
Regards,
Riki
--- Reshat Sabiq <sabiq(at)purdue(dot)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(at)postgresql(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Kaitharam, Ananth | 2003-06-17 12:25:04 | Indexed access for INET/ CIDR datatype |
Previous Message | Joe Conway | 2003-06-17 10:26:02 | Re: use cursor in a function |