SQL:CREATE TABLE 的深入研究

在預設的情況下新增一個表指定
1.serial:
系統會自動產生一個 Sequence 物件, 並以"[TableName]_[ColumnName]_seq"進行命名.
2.PRIMARY KEY:
系統會自動產生一個 Constraint 物件, 並以"[TableName]_pkey"進行命名.

範例
=# CREATE TABLE test1
-# (
(# id serial PRIMARY KEY,
(# my_url varchar(50)
(# );
------------------------------------------------------------------------------------
NOTICE: CREATE TABLE will create implicit sequence "test1_id_seq" for serial column "test1.id"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "test1_pkey" for table "test1"
CREATE TABLE
=#

如上的範例, 但系統在背後轉成正式語法如下:
CREATE TABLE test1
(
id serial NOT NULL,
my_url character varying(50),
CONSTRAINT test1_pkey PRIMARY KEY (id)
)
WITHOUT OIDS;
ALTER TABLE test1 OWNER TO postgres;