Postgres Pro
Downloads
Home   >   mailing lists

saving a view with pg_dump - Mailing list pgsql-general

From Johnson, Shaunn
Subject saving a view with pg_dump
Date
Msg-id 73309C2FDD95D11192E60008C7B1D5BB04C73D5B@snt452.corp.bcbsm.com
Whole thread Raw
Responses Re: saving a view with pg_dump  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view

Howdy:

Running PostgreSQL 7.1.3 (migrating to 7.2.1) and
I'm dumping the database with pg_dump (from the 7.2.1
version). 

Is it possible to use pg_dump to create a file for
a view / sequence / etc?  I don't have all of the scripts
that recreate all of the views, so I'm wondering if it's
better to use pg_dump (if I can) and make a copy of them.

Thanks!

-X

pgsql-general by date:

Previous
From: Ralph Graulich
Date:
Subject: Reviewed: max. no of relations in a database
Next
From: Tom Lane
Date:
Subject: Re: saving a view with pg_dump