我刚刚在Postgres中创建了一个表,并收到一条通知消息,我对隐式索引和序列并不完全了解.任何澄清将不胜感激.
原文链接：/postgresql/452771.htmlmy_database=# CREATE TABLE sites my_database-# ( my_database(# site_id_key serial primary key,my_database(# site_url VARCHAR(255),my_database(# note VARCHAR(255),my_database(# type INTEGER,my_database(# last_visited TIMESTAMP my_database(# ) ; NOTICE: CREATE TABLE will create implicit sequence "sites_site_id_key_seq" for serial column "sites_to_search.site_id_key" NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "sites_pkey" for table "sites_to_search" CREATE TABLE
