aboutsummaryrefslogtreecommitdiff
path: root/doc/man/alter_table.l
diff options
context:
space:
mode:
Diffstat (limited to 'doc/man/alter_table.l')
-rw-r--r--doc/man/alter_table.l61
1 files changed, 0 insertions, 61 deletions
diff --git a/doc/man/alter_table.l b/doc/man/alter_table.l
deleted file mode 100644
index 245533a03c4..00000000000
--- a/doc/man/alter_table.l
+++ /dev/null
@@ -1,61 +0,0 @@
-.\" This is -*-nroff-*-
-.\" XXX standard disclaimer belongs here....
-.\" $Header: /cvsroot/pgsql/doc/man/Attic/alter_table.l,v 1.1.1.1 1996/08/18 22:14:19 scrappy Exp $
-.TH "ALTER TABLE" SQL 11/5/95 Postgres95 Postgres95
-.SH NAME
-alter table \(em add attributes to a class
-.SH SYNOPSIS
-.nf
-\fBalter table\fR classname [*]
- \fBadd column\fR attname type
-
-.fi
-.SH DESCRIPTION
-The
-.BR "alter table"
-command
-causes a new attribute to be added to an existing class,
-.IR classname .
-The new attributes and their types are specified
-in the same style and with the the same restrictions as in
-.IR create table (l).
-.PP
-In order to add an attribute to each class in an entire inheritance
-hierarchy, use the
-.IR classname
-of the superclass and append a \*(lq*\*(rq. (By default, the
-attribute will not be added to any of the subclasses.) This should
-.BR always
-be done when adding an attribute to a superclass. If it is not,
-queries on the inheritance hierarchy such as
-.nf
-select * from super* s
-.fi
-will not work because the subclasses will be missing an attribute
-found in the superclass.
-.PP
-For efficiency reasons, default values for added attributes are not
-placed in existing instances of a class. That is, existing instances
-will have NULL values in the new attributes. If non-NULL values are
-desired, a subsequent
-.IR update (l)
-query should be run.
-.PP
-You must own the class in order to change its schema.
-.SH EXAMPLE
-.nf
---
--- add the date of hire to the emp class
---
-alter table emp add column hiredate abstime
-.fi
-.nf
---
--- add a health-care number to all persons
--- (including employees, students, ...)
---
-alter table person * add column health_care_id int4
-.fi
-.SH "SEE ALSO"
-create table (l),
-update (l).