0

is it posible to see how a Database View is constructed in Postgres, to see wich query was used to create that view?

JhonDoe
  • 27
  • 6

1 Answers1

1

In psql:

\d+ the_view

--or

select definition from pg_views where viewname = 'the_view';
Adrian Klaver
  • 15,886
  • 2
  • 17
  • 28