diff options
| author | Robert Haas <rhaas@postgresql.org> | 2011-01-01 23:48:11 -0500 |
|---|---|---|
| committer | Robert Haas <rhaas@postgresql.org> | 2011-01-01 23:48:11 -0500 |
| commit | 0d692a0dc9f0e532c67c577187fe5d7d323cb95b (patch) | |
| tree | 5177be3794b8ffa768a3cd852221425bd2a74347 /doc/src/sgml/ref/comment.sgml | |
| parent | 6600d5e91c754789002ed794c18cb856c190f58f (diff) | |
| download | postgresql-0d692a0dc9f0e532c67c577187fe5d7d323cb95b.tar.gz | |
Basic foreign table support.
Foreign tables are a core component of SQL/MED. This commit does
not provide a working SQL/MED infrastructure, because foreign tables
cannot yet be queried. Support for foreign table scans will need to
be added in a future patch. However, this patch creates the necessary
system catalog structure, syntax support, and support for ancillary
operations such as COMMENT and SECURITY LABEL.
Shigeru Hanada, heavily revised by Robert Haas
Diffstat (limited to 'doc/src/sgml/ref/comment.sgml')
| -rw-r--r-- | doc/src/sgml/ref/comment.sgml | 8 |
1 files changed, 5 insertions, 3 deletions
diff --git a/doc/src/sgml/ref/comment.sgml b/doc/src/sgml/ref/comment.sgml index d81fd72641..f1a1605df3 100644 --- a/doc/src/sgml/ref/comment.sgml +++ b/doc/src/sgml/ref/comment.sgml @@ -31,6 +31,7 @@ COMMENT ON CONVERSION <replaceable class="PARAMETER">object_name</replaceable> | DATABASE <replaceable class="PARAMETER">object_name</replaceable> | DOMAIN <replaceable class="PARAMETER">object_name</replaceable> | + FOREIGN TABLE <replaceable class="PARAMETER">object_name</replaceable> | FUNCTION <replaceable class="PARAMETER">function_name</replaceable> ( [ [ <replaceable class="parameter">argmode</replaceable> ] [ <replaceable class="parameter">argname</replaceable> ] <replaceable class="parameter">argtype</replaceable> [, ...] ] ) | INDEX <replaceable class="PARAMETER">object_name</replaceable> | LARGE OBJECT <replaceable class="PARAMETER">large_object_oid</replaceable> | @@ -96,9 +97,9 @@ COMMENT ON <listitem> <para> The name of the object to be commented. Names of tables, - aggregates, domains, functions, indexes, operators, operator classes, - operator families, sequences, text search objects, types, and views can - be schema-qualified. + aggregates, domains, foreign tables, functions, indexes, operators, + operator classes, operator families, sequences, text search objects, + types, and views can be schema-qualified. </para> </listitem> </varlistentry> @@ -247,6 +248,7 @@ COMMENT ON COLUMN my_table.my_column IS 'Employee ID number'; COMMENT ON CONVERSION my_conv IS 'Conversion to UTF8'; COMMENT ON DATABASE my_database IS 'Development Database'; COMMENT ON DOMAIN my_domain IS 'Email Address Domain'; +COMMENT ON FOREIGN TABLE my_foreign_table IS 'Employee Information in other database'; COMMENT ON FUNCTION my_function (timestamp) IS 'Returns Roman Numeral'; COMMENT ON INDEX my_index IS 'Enforces uniqueness on employee ID'; COMMENT ON LANGUAGE plpython IS 'Python support for stored procedures'; |