Thread: Backup/Restore Views

What is the most simple way to backup and restore only views?

Randall

Your best bet would be to query the system tables. Something like

SELECT definition FROM pg_views;

On Thu, Nov 03, 2005 at 12:43:47PM -0600, Randall Smith wrote:
> What is the most simple way to backup and restore only views?
>
> Randall
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
>               http://archives.postgresql.org
>

--
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461