Skip to content

Instantly share code, notes, and snippets.

@sawirricardo

sawirricardo/select_views_postgres.sql

Created January 20, 2024 08:24
Show Gist options
  • Save sawirricardo/4e8c1c3cecb70aae606575fcaa72dc99 to your computer and use it in GitHub Desktop.
Save sawirricardo/4e8c1c3cecb70aae606575fcaa72dc99 to your computer and use it in GitHub Desktop.
Download ZIP
Select views for postgresql
Raw
select_views_postgres.sql
select
viewname as name,
schemaname as schema,
definition from pg_views
where
schemaname not in ('pg_catalog', 'information_schema')
order by
viewname;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment