select pg_get_viewdef('viewname', true)

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

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

一直不得不返回这里查找pg_get_viewdef(如何记住!!)，所以搜索一个更容易记住的命令…并得到了它:

\d+ viewname

你可以通过输入\?在PGSQL命令行。

额外提示:emacs命令sql-postgres使pgsql更加方便(编辑、复制、粘贴、命令历史)。

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

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

找到'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>