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 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
