Dump only views from a postgres database

gistfile1.txt

#!/bin/bash
VIEWS="" ; for view in $(psql -U postgres -c 'select schemaname || $$.$$ ||viewname from pg_views where schemaname::text !~ $$information_schema|pg_catalog$$ ' -tA) ; do  VIEWS="$VIEWS -t $view"  ; done ; /opt/pg/bin/pg_dump -Upostgres -c -s $VIEWS

Optionally you can dump into a file:

VIEWS="" ; for view in $(psql -U postgres  -c 'select schemaname || $$.$$ ||viewname from pg_views where schemaname::text !~ $$information_schema|pg_catalog$$ ' -tA) ; do  VIEWS="$VIEWS -t $view"  ; done ; /opt/pg/bin/pg_dump -Upostgres -c -s $VIEWS -f view_dump.sql


=====
#!/usr/local/bin/bash
DB=$1
PGBIN=/usr/local/bin
VIEWS="" ; for view in $($PGBIN/psql -U $USER $DB  -c 'select schemaname || $$.$$ ||viewname from pg_views where schemaname::text !~ $$information_schema|pg_catalog$$ ' -tA) ; do  VIEWS="$VIEWS -t $view"  ; done ; $PGBIN/pg_dump -U $USER -c -s $VIEWS -f view_dump.sql $DB

#!/usr/local/bin/bash
DB=$1
DIA=$(date +%Y%m%d%H%M)
PGBIN=/usr/local/bin
VIEWS="" ; for view in $($PGBIN/psql -U $USER $DB  -c 'select schemaname || $$.$$ ||viewname from pg_views where schemaname::text !~ $$information_schema|pg_catalog$$ ' -tA) ; do  VIEWS="$VIEWS -t $view"  ; done ; $PGBIN/pg_dump -U $USER
 -c -s $VIEWS -f view_dump.sql $DB

uuencode view_dump.sql view_dump_$DIA.sql | mail -s "Backup vistas" [email protected]
uuencode view_dump.sql view_dump_$DIA.sql | mail -s "Backup vistas" [email protected]