Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id BEEB79FB7C8 for ; Fri, 5 Oct 2007 18:12:11 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 96365-02 for ; Fri, 5 Oct 2007 18:11:57 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from smtp156.iad.emailsrvr.com (smtp156.iad.emailsrvr.com [207.97.245.156]) by postgresql.org (Postfix) with ESMTP id 74F119FB78C for ; Fri, 5 Oct 2007 18:12:05 -0300 (ADT) Received: from relay5.relay.iad.emailsrvr.com (localhost [127.0.0.1]) by relay5.relay.iad.emailsrvr.com (SMTP Server) with ESMTP id A55B164ABB9; Fri, 5 Oct 2007 17:12:02 -0400 (EDT) Received: by relay5.relay.iad.emailsrvr.com (Authenticated sender: erik-AT-myemma.com) with ESMTP id 81D4164A78D; Fri, 5 Oct 2007 17:12:02 -0400 (EDT) In-Reply-To: <47066D42.6050003@correolux.com.mx> References: <47066D42.6050003@correolux.com.mx> Mime-Version: 1.0 (Apple Message framework v752.3) Content-Type: text/plain; charset=ISO-8859-1; delsp=yes; format=flowed Message-Id: Cc: pgsql-sql@postgresql.org Content-Transfer-Encoding: quoted-printable From: Erik Jones Subject: Re: pg_dump question Date: Fri, 5 Oct 2007 16:11:35 -0500 To: Judith X-Mailer: Apple Mail (2.752.3) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200710/34 X-Sequence-Number: 29406 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 =20 > pg_dump -s, but I want to restore but just with some tables with =20 > the db catalogues, can I do this?, I mean, restore al the db =20 > structure without data and after restore the data of the catalogues =20= > tables?? Don't worry about the catalog tables. If all you want is the schema =20 dumped and restored then, yes, use the -s flag. The data in the =20 catalog tables is built as the schema is rebuilt during the restore, =20 i.e postgres takes care of those for you. Erik Jones Software Developer | Emma=AE 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