Skip to content

Instantly share code, notes, and snippets.

@sawirricardo
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.
Select views for postgresql
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