* Andrew Dunstan (andrew@dunslane.net) wrote:
> 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?
Create the appropriate table definition, and then load it up? Of
course, an option to have the pg_dump include the table definition
derived from the view would be nice also.
Thanks,
Stephen