PostgreSQL : SQL Commands : CREATE TABLE

Context of the notion in the technology: Document / Topc: PostgreSQL
Document / Topc: SQL Commands
Related Keywords: Postgre SQL SQL Commands CREATE TABLE
Help URL: http://www.postgresql.org/docs/8.1/interactive/sql-createtable.html


Items Related to CREATE TABLE

Inner Elements of CREATE TABLE

CREATE TABLE contains following items:
  • GLOBAL
  • LOCAL
  • TEMPORARY
  • TEMP
  • DEFAULT
  • LIKE
  • INCLUDING
  • EXCLUDING
  • DEFAULTS
  • INHERITS
  • WITH
  • OIDS
  • WITHOUT
  • COMMIT
  • PRESERVE
  • ROWS
  • DELETE
  • DROP
  • TABLESPACE
  • CONSTRAINT
  • NOT
  • NULL
  • UNIQUE
  • USING
  • INDEX
  • PRIMARY
  • KEY
  • CHECK
  • REFERENCES
  • MATCH
  • FULL
  • PARTIAL
  • SIMPLE
  • UPDATE
  • DEFERRABLE
  • INITIALLY
  • DEFERRED
  • IMMEDIATE
  • FOREIGN


PostgreSQL is a free object-relational database server (database management system), released under a flexible BSD-style license. It offers an alternative to other open-source database systems (such as MySQL and Firebird), as well as to proprietary systems such as Oracle, Sybase, IBM's DB2 and Microsoft SQL Server. Similar to other open-source projects such as Apache, Linux, and Mediawiki, PostgreSQL is not controlled by any single company, but relies on a global community of developers and companies to develop it.
   -- wikipedia.org
Home