| From: | Reshat Sabiq <sabiq(at)purdue(dot)edu> |
|---|---|
| To: | Don Patou <pknoob(at)noos(dot)fr> |
| Cc: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: using a dumped database file |
| Date: | 2003-06-16 20:35:59 |
| Message-ID: | 3EEE2A2F.5020103@purdue.edu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Vamsee Koneru | 2003-06-16 21:30:52 | Sequence-table association |
| Previous Message | Don Patou | 2003-06-16 20:29:51 | using a dumped database file |