Is there anyway to export a view from one database to another? I cant seem to figure this out without having to manually recreate the views.
Thanks,
Jesse
pg_dump dbname -t viewname|psql otherdb
should do it.
awsome thanks for your help. Will give it a shot!
