saving a view with pg_dump

From: "Johnson, Shaunn" <SJohnson6(at)bcbsm(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: saving a view with pg_dump
Date: 2002-08-02 23:59:36
Message-ID: 73309C2FDD95D11192E60008C7B1D5BB04C73D5B@snt452.corp.bcbsm.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2002-08-03 00:07:22 Re: saving a view with pg_dump
Previous Message Ralph Graulich 2002-08-02 23:52:07 Reviewed: max. no of relations in a database