diff options
| author | Bruce Momjian <bruce@momjian.us> | 2011-02-01 17:17:34 -0500 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2011-02-01 17:17:34 -0500 |
| commit | 5a6ba62be5364dbf973fd9b8631fd60acda03440 (patch) | |
| tree | 3350452dc8a6ea0d34ba1a59194cfab396e6282e | |
| parent | d56d246e70184692408cd6a444e6824ae8491587 (diff) | |
| download | postgresql-5a6ba62be5364dbf973fd9b8631fd60acda03440.tar.gz postgresql-5a6ba62be5364dbf973fd9b8631fd60acda03440.zip | |
Document that CREATE VIEW that uses "*" for the column list will not
auto-add columns later added to the base table.
| -rw-r--r-- | doc/src/sgml/ref/create_view.sgml | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/doc/src/sgml/ref/create_view.sgml b/doc/src/sgml/ref/create_view.sgml index dd155078111..417f8c38e7e 100644 --- a/doc/src/sgml/ref/create_view.sgml +++ b/doc/src/sgml/ref/create_view.sgml @@ -173,6 +173,10 @@ CREATE VIEW comedies AS FROM films WHERE kind = 'Comedy'; </programlisting> + This will create a view containing the columns that are in the + <literal>film</> table at the time of view creation. Though + <literal>*</> was used to create the view, columns added later to + the table will not be part of the view. </para> </refsect1> |