| From: | Erik Jones <erik(at)myemma(dot)com> |
|---|---|
| To: | Judith <jaltamirano(at)correolux(dot)com(dot)mx> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: pg_dump question |
| Date: | 2007-10-05 21:11:35 |
| Message-ID: | CBD44097-66F0-41B3-B957-6A7DABD4AEAC@myemma.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
On Oct 5, 2007, at 11:58 AM, Judith wrote:
> Hello every body!! I have a quesyion respect pg_dump...........
>
> I need to backup the db structure, I suposse that I do with
> pg_dump -s, but I want to restore but just with some tables with
> the db catalogues, can I do this?, I mean, restore al the db
> structure without data and after restore the data of the catalogues
> tables??
Don't worry about the catalog tables. If all you want is the schema
dumped and restored then, yes, use the -s flag. The data in the
catalog tables is built as the schema is rebuilt during the restore,
i.e postgres takes care of those for you.
Erik Jones
Software Developer | Emma®
erik(at)myemma(dot)com
800.595.4401 or 615.292.5888
615.292.0777 (fax)
Emma helps organizations everywhere communicate & market in style.
Visit us online at http://www.myemma.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Aroon Pahwa | 2007-10-05 21:33:20 | valid query runs forever? |
| Previous Message | Judith | 2007-10-05 16:58:42 | pg_dump question |