is it posible to see how a Database View is constructed in Postgres, to see wich query was used to create that view?
Asked
Active
Viewed 96 times
1 Answers
1
In psql
:
\d+ the_view
--or
select definition from pg_views where viewname = 'the_view';

Adrian Klaver
- 15,886
- 2
- 17
- 28