From: | Jasen Betts <jasen(at)xnet(dot)co(dot)nz> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Schema, database, or tables in different folders? |
Date: | 2009-06-08 11:16:57 |
Message-ID: | h0irv9$bu8$2@reversiblemaps.ath.cx |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 2009-06-02, Carlos Oliva <CarlosO(at)pbsinet(dot)com> wrote:
> This is a multi-part message in MIME format.
>
> ------_=_NextPart_001_01C9E386.D2E5B79B
> Content-Type: text/plain;
> charset="us-ascii"
> Content-Transfer-Encoding: quoted-printable
>
> Is there a way to create a database or a table of a database in its own
> folder?
this is what tablespaces are.
> We are looking for ways to backup the sytem files of the
> database to tape and one to exclude some tables from this backup.
pg_dump has options to include only named tables,
so you could in theory name all ther other tables on the command-line
but what I do (being lazy) is use sed to remove the unwanted tables from the dump.
sed '/^COPY unwantd_table ([^ ]*) FROM stdin;$/,/^\\.$/ d'
the whitespace inside the [] is a tab character.
From | Date | Subject | |
---|---|---|---|
Next Message | Grand, Mark D. | 2009-06-08 11:28:20 | Re: invalid byte sequence for encoding "UTF8": 0xab |
Previous Message | Vlado Moravec | 2009-06-08 10:48:04 | Foreign Key Unique Constraint can be dropped |