Postgres Pro
Downloads
Home   >   mailing lists

Re: feature request: pg_dump --view - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: feature request: pg_dump --view
Date
Msg-id 44BD7485.9030409@dunslane.net
Whole thread Raw
In response to Re: feature request: pg_dump --view  (elein <elein@varlena.com>)
Responses Re: feature request: pg_dump --view  (Stephen Frost <sfrost@snowman.net>)
List pgsql-hackers
Tree view 
elein wrote:
>> pg_dump -t <view_name> will work.
>>
>>     
>
> Oh, you got me all worked up.  I was reading this as a way to
> dump the CONTENTS of a view not the DEFINITION of a view.
> I thought someone sneaked in pg_dump of a query in there.
>
>   

How would you load such a dump, since views are by default select-only?

cheers

andrew

pgsql-hackers by date:

Previous
From: elein
Date:
Subject: Re: feature request: pg_dump --view
Next
From: Tom Lane
Date:
Subject: Re: [COMMITTERS] pgsql: Done: o -Display IN, INOUT, and OUT parameters in \df