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

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