Re: Schema, database, or tables in different folders?

On 2009-06-02, Carlos Oliva <CarlosO@pbsinet.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.