select definition from pg_views where viewname = 'my_view'

select definition from pg_views where viewname = 'my_view'

select pg_get_viewdef('viewname', true)

手册中列出了所有这些功能:

http://www.postgresql.org/docs/current/static/functions-info.html

找到'CREATE TABLE…的查询是使用这个查询-

SHOW TABLE your_schema_name.your_table_name

These is a little thing to point out. Using the function pg_get_viewdef or pg_views or information_schema.views you will always get a rewritten version of your original DDL. The rewritten version may or not be the same as your original DDL script. If the Rule Manager rewrite your view definition your original DLL will be lost and you will able to read the only the rewritten version of your view definition. Not all views are rewritten but if you use sub-select or joins probably your views will be rewritten.

在命令行客户端psql中，您可以使用以下命令:

\sv <VIEWNAME>