Add PRIMARY KEY in table creation : Primary Key « Constraints « PostgreSQL

1.	Aggregate Functions
2.	Analytical Functions
3.	Array
4.	Constraints
5.	Cursor
6.	Data Type
7.	Database
8.	Date Timezone
9.	Index
10.	Inheritance
11.	Insert Delete Update
12.	Math Functions
13.	Postgre SQL
14.	Select Query
15.	Sequence
16.	Store Procedure Function
17.	String Functions
18.	Subquery
19.	Table
20.	Table Joins
21.	Transaction
22.	User Previliege
23.	View

PostgreSQL » Constraints » Primary Key

Add PRIMARY KEY in table creation





postgres=#

postgres=# CREATE TABLE new_books

postgres-#               (id integer CONSTRAINT books_id_pkey PRIMARY KEY,

postgres(#               title text NOT NULL,

postgres(#               author_id integer,

postgres(#               subject_id integer);

NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "books_id_pkey" for table "new_books"

CREATE TABLE

postgres=#

postgres=# drop table new_books;

DROP TABLE

postgres=#

Related examples in the same category

1.	Implicit index is created when creating a table for a primary key
2.	Primary keys constrains more than one column
3.	Indicate one column as the primary key column
4.	PRIMARY KEY will create implicit index
5.	Primary key with check option
6.	Use sequence value as a primary key

java2s.com | Contact Us | Privacy Policy

All other trademarks are property of their respective owners.