On 2009-06-02, Carlos Oliva <CarlosO@xxxxxxxxxxx> 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. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
