Specifying two constaint for a single table : Constraints Basics « 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 » Constraints Basics

Specifying two constaint for a single table





postgres=#

postgres=#

postgres=# CREATE TABLE products (

postgres(#    product_no integer NOT NULL,

postgres(#    name text NOT NULL,

postgres(#    price numeric NOT NULL CHECK (price > 0)

postgres(# );

CREATE TABLE

postgres=#

postgres=# drop table products;

DROP TABLE

postgres=#

Related examples in the same category

1.	Null column
2.	Primary key with check option
3.	Specifying range check in table creation

java2s.com | Contact Us | Privacy Policy

All other trademarks are property of their respective owners.