| <!-- |
| $PostgreSQL: pgsql/doc/src/sgml/ref/alter_external_table.sgml,v 1.105 2006/09/16 00:30:17 momjian Exp $ |
| PostgreSQL documentation |
| --> |
| |
| <refentry id="SQL-ALTEREXTERNALTABLE"> |
| <refmeta> |
| <refentrytitle id="sql-alterexternaltable-title">ALTER EXTERNAL TABLE</refentrytitle> |
| <refmiscinfo>SQL - Language Statements</refmiscinfo> |
| </refmeta> |
| |
| <refnamediv> |
| <refname>ALTER EXTERNAL TABLE</refname> |
| <refpurpose>change the definition of an external table</refpurpose> |
| </refnamediv> |
| |
| <indexterm zone="sql-alterexternaltable"> |
| <primary>ALTER EXTERNAL TABLE</primary> |
| </indexterm> |
| |
| <refsynopsisdiv> |
| <synopsis> |
| ALTER EXTERNAL TABLE name RENAME [COLUMN] column TO new_column |
| |
| ALTER EXTERNAL TABLE name RENAME TO new_name |
| |
| ALTER EXTERNAL TABLE name SET SCHEMA new_schema |
| |
| ALTER EXTERNAL TABLE name action [, ... ] |
| |
| where action is one of: |
| ADD [COLUMN] column_name type |
| DROP [COLUMN] column |
| ALTER [COLUMN] column TYPE type [USING expression] |
| OWNER TO new_owner |
| |
| </synopsis> |
| |
| </refsynopsisdiv> |
| |
| <refsect1 id="SQL-ALTEREXTERNALTABLE-description"> |
| <title>Description</title> |
| |
| <para> |
| |
| </para> |
| |
| |
| </refsect1> |
| |
| <refsect1> |
| <title>Parameters</title> |
| |
| </refsect1> |
| |
| <refsect1 id="SQL-ALTEREXTERNALTABLE-notes"> |
| <title>Notes</title> |
| |
| |
| |
| </refsect1> |
| |
| |
| |
| |
| |
| <refsect1 id="SQL-ALTEREXTERNALTABLE-examples"> |
| <title>Examples</title> |
| |
| |
| |
| </refsect1> |
| |
| <refsect1> |
| <title>See Also</title> |
| |
| |
| </refsect1> |
| </refentry> |