1#@!#!123s

: / usr / share / doc / postgresql-9.2.24 / html /
Filename : ddl.html
back
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<HTML
><HEAD
><TITLE
>Data Definition</TITLE
><META
NAME="GENERATOR"
CONTENT="Modular DocBook HTML Stylesheet Version 1.79"><LINK
REV="MADE"
HREF="mailto:pgsql-docs@postgresql.org"><LINK
REL="HOME"
TITLE="PostgreSQL 9.2.24 Documentation"
HREF="index.html"><LINK
REL="UP"
TITLE="The SQL Language"
HREF="sql.html"><LINK
REL="PREVIOUS"
TITLE="Calling Functions"
HREF="sql-syntax-calling-funcs.html"><LINK
REL="NEXT"
TITLE="Table Basics"
HREF="ddl-basics.html"><LINK
REL="STYLESHEET"
TYPE="text/css"
HREF="stylesheet.css"><META
HTTP-EQUIV="Content-Type"
CONTENT="text/html; charset=ISO-8859-1"><META
NAME="creation"
CONTENT="2017-11-06T22:43:11"></HEAD
><BODY
CLASS="CHAPTER"
><DIV
CLASS="NAVHEADER"
><TABLE
SUMMARY="Header navigation table"
WIDTH="100%"
BORDER="0"
CELLPADDING="0"
CELLSPACING="0"
><TR
><TH
COLSPAN="5"
ALIGN="center"
VALIGN="bottom"
><A
HREF="index.html"
>PostgreSQL 9.2.24 Documentation</A
></TH
></TR
><TR
><TD
WIDTH="10%"
ALIGN="left"
VALIGN="top"
><A
TITLE="Calling Functions"
HREF="sql-syntax-calling-funcs.html"
ACCESSKEY="P"
>Prev</A
></TD
><TD
WIDTH="10%"
ALIGN="left"
VALIGN="top"
><A
HREF="sql.html"
ACCESSKEY="U"
>Up</A
></TD
><TD
WIDTH="60%"
ALIGN="center"
VALIGN="bottom"
></TD
><TD
WIDTH="20%"
ALIGN="right"
VALIGN="top"
><A
TITLE="Table Basics"
HREF="ddl-basics.html"
ACCESSKEY="N"
>Next</A
></TD
></TR
></TABLE
><HR
ALIGN="LEFT"
WIDTH="100%"></DIV
><DIV
CLASS="CHAPTER"
><H1
><A
NAME="DDL"
></A
>Chapter 5. Data Definition</H1
><DIV
CLASS="TOC"
><DL
><DT
><B
>Table of Contents</B
></DT
><DT
>5.1. <A
HREF="ddl-basics.html"
>Table Basics</A
></DT
><DT
>5.2. <A
HREF="ddl-default.html"
>Default Values</A
></DT
><DT
>5.3. <A
HREF="ddl-constraints.html"
>Constraints</A
></DT
><DD
><DL
><DT
>5.3.1. <A
HREF="ddl-constraints.html#DDL-CONSTRAINTS-CHECK-CONSTRAINTS"
>Check Constraints</A
></DT
><DT
>5.3.2. <A
HREF="ddl-constraints.html#AEN2471"
>Not-Null Constraints</A
></DT
><DT
>5.3.3. <A
HREF="ddl-constraints.html#DDL-CONSTRAINTS-UNIQUE-CONSTRAINTS"
>Unique Constraints</A
></DT
><DT
>5.3.4. <A
HREF="ddl-constraints.html#DDL-CONSTRAINTS-PRIMARY-KEYS"
>Primary Keys</A
></DT
><DT
>5.3.5. <A
HREF="ddl-constraints.html#DDL-CONSTRAINTS-FK"
>Foreign Keys</A
></DT
><DT
>5.3.6. <A
HREF="ddl-constraints.html#DDL-CONSTRAINTS-EXCLUSION"
>Exclusion Constraints</A
></DT
></DL
></DD
><DT
>5.4. <A
HREF="ddl-system-columns.html"
>System Columns</A
></DT
><DT
>5.5. <A
HREF="ddl-alter.html"
>Modifying Tables</A
></DT
><DD
><DL
><DT
>5.5.1. <A
HREF="ddl-alter.html#DDL-ALTER-ADDING-A-COLUMN"
>Adding a Column</A
></DT
><DT
>5.5.2. <A
HREF="ddl-alter.html#DDL-ALTER-REMOVING-A-COLUMN"
>Removing a Column</A
></DT
><DT
>5.5.3. <A
HREF="ddl-alter.html#DDL-ALTER-ADDING-A-CONSTRAINT"
>Adding a Constraint</A
></DT
><DT
>5.5.4. <A
HREF="ddl-alter.html#DDL-ALTER-REMOVING-A-CONSTRAINT"
>Removing a Constraint</A
></DT
><DT
>5.5.5. <A
HREF="ddl-alter.html#AEN2786"
>Changing a Column's Default Value</A
></DT
><DT
>5.5.6. <A
HREF="ddl-alter.html#AEN2796"
>Changing a Column's Data Type</A
></DT
><DT
>5.5.7. <A
HREF="ddl-alter.html#AEN2806"
>Renaming a Column</A
></DT
><DT
>5.5.8. <A
HREF="ddl-alter.html#AEN2813"
>Renaming a Table</A
></DT
></DL
></DD
><DT
>5.6. <A
HREF="ddl-priv.html"
>Privileges</A
></DT
><DT
>5.7. <A
HREF="ddl-schemas.html"
>Schemas</A
></DT
><DD
><DL
><DT
>5.7.1. <A
HREF="ddl-schemas.html#DDL-SCHEMAS-CREATE"
>Creating a Schema</A
></DT
><DT
>5.7.2. <A
HREF="ddl-schemas.html#DDL-SCHEMAS-PUBLIC"
>The Public Schema</A
></DT
><DT
>5.7.3. <A
HREF="ddl-schemas.html#DDL-SCHEMAS-PATH"
>The Schema Search Path</A
></DT
><DT
>5.7.4. <A
HREF="ddl-schemas.html#DDL-SCHEMAS-PRIV"
>Schemas and Privileges</A
></DT
><DT
>5.7.5. <A
HREF="ddl-schemas.html#DDL-SCHEMAS-CATALOG"
>The System Catalog Schema</A
></DT
><DT
>5.7.6. <A
HREF="ddl-schemas.html#DDL-SCHEMAS-PATTERNS"
>Usage Patterns</A
></DT
><DT
>5.7.7. <A
HREF="ddl-schemas.html#DDL-SCHEMAS-PORTABILITY"
>Portability</A
></DT
></DL
></DD
><DT
>5.8. <A
HREF="ddl-inherit.html"
>Inheritance</A
></DT
><DT
>5.9. <A
HREF="ddl-partitioning.html"
>Partitioning</A
></DT
><DD
><DL
><DT
>5.9.1. <A
HREF="ddl-partitioning.html#DDL-PARTITIONING-OVERVIEW"
>Overview</A
></DT
><DT
>5.9.2. <A
HREF="ddl-partitioning.html#DDL-PARTITIONING-IMPLEMENTATION"
>Implementing Partitioning</A
></DT
><DT
>5.9.3. <A
HREF="ddl-partitioning.html#DDL-PARTITIONING-MANAGING-PARTITIONS"
>Managing Partitions</A
></DT
><DT
>5.9.4. <A
HREF="ddl-partitioning.html#DDL-PARTITIONING-CONSTRAINT-EXCLUSION"
>Partitioning and Constraint Exclusion</A
></DT
><DT
>5.9.5. <A
HREF="ddl-partitioning.html#DDL-PARTITIONING-ALTERNATIVES"
>Alternative Partitioning Methods</A
></DT
><DT
>5.9.6. <A
HREF="ddl-partitioning.html#DDL-PARTITIONING-CAVEATS"
>Caveats</A
></DT
></DL
></DD
><DT
>5.10. <A
HREF="ddl-foreign-data.html"
>Foreign Data</A
></DT
><DT
>5.11. <A
HREF="ddl-others.html"
>Other Database Objects</A
></DT
><DT
>5.12. <A
HREF="ddl-depend.html"
>Dependency Tracking</A
></DT
></DL
></DIV
><P
>  This chapter covers how one creates the database structures that
  will hold one's data.  In a relational database, the raw data is
  stored in tables, so the majority of this chapter is devoted to
  explaining how tables are created and modified and what features are
  available to control what data is stored in the tables.
  Subsequently, we discuss how tables can be organized into
  schemas, and how privileges can be assigned to tables.  Finally,
  we will briefly look at other features that affect the data storage,
  such as inheritance, views, functions, and triggers.
 </P
></DIV
><DIV
CLASS="NAVFOOTER"
><HR
ALIGN="LEFT"
WIDTH="100%"><TABLE
SUMMARY="Footer navigation table"
WIDTH="100%"
BORDER="0"
CELLPADDING="0"
CELLSPACING="0"
><TR
><TD
WIDTH="33%"
ALIGN="left"
VALIGN="top"
><A
HREF="sql-syntax-calling-funcs.html"
ACCESSKEY="P"
>Prev</A
></TD
><TD
WIDTH="34%"
ALIGN="center"
VALIGN="top"
><A
HREF="index.html"
ACCESSKEY="H"
>Home</A
></TD
><TD
WIDTH="33%"
ALIGN="right"
VALIGN="top"
><A
HREF="ddl-basics.html"
ACCESSKEY="N"
>Next</A
></TD
></TR
><TR
><TD
WIDTH="33%"
ALIGN="left"
VALIGN="top"
>Calling Functions</TD
><TD
WIDTH="34%"
ALIGN="center"
VALIGN="top"
><A
HREF="sql.html"
ACCESSKEY="U"
>Up</A
></TD
><TD
WIDTH="33%"
ALIGN="right"
VALIGN="top"
>Table Basics</TD
></TR
></TABLE
></DIV
></BODY
></HTML
>