From: Erik Jones <erik@myemma.com>
To: Judith <jaltamirano@correolux.com.mx>
Cc: pgsql-sql@postgresql.org
Subject: Re: pg_dump question
Date: Fri, 5 Oct 2007 16:11:35 -0500
Message-ID: <CBD44097-66F0-41B3-B957-6A7DABD4AEAC@myemma.com> (raw)
In-Reply-To: <47066D42.6050003@correolux.com.mx>
References: <47066D42.6050003@correolux.com.mx>
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@myemma.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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: erik@myemma.com, jaltamirano@correolux.com.mx
Subject: Re: pg_dump question
In-Reply-To: <CBD44097-66F0-41B3-B957-6A7DABD4AEAC@myemma.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox