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

\sv <VIEWNAME>

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.

select pg_get_viewdef('viewname', true)

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

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

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

\sv <VIEWNAME>

如果你想要一个ANSI SQL-92版本:

select view_definition from information_schema.views where table_name = 'view_name';

select definition from pg_views where viewname = 'my_view'