REFERENCES ref_table [ ( ref_column [, ... ] ) ] [ MATCH FULL | MATCH PARTIAL | MATCH SIMPLE ] [ ON DELETE action ] [ ON UPDATE action ] } [ DEFERRABLE | NOT DEFERRABLE ] [ INITIALLY DEFERRED | INITIALLY IMMEDIATE ] 更多关于大数据 PostgreSQL 系列的学习文章,请参阅:PostgreSQL 数据库...
[ CONSTRAINT constraint_name ] { NOT NULL | NULL | UNIQUE [ USING INDEX TABLESPACE tablespace ] | PRIMARY KEY [ USING INDEX TABLESPACE tablespace ] | CHECK (expression) | REFERENCES ref_table [ ( ref_column ) ] [ MATCH FULL | MATCH PARTIAL | MATCH SIMPLE ] [ ON DELETE action ] [ ...
[ CONSTRAINT constraint_name ] { NOT NULL | NULL | UNIQUE [ USING INDEX TABLESPACE tablespace ] | PRIMARY KEY [ USING INDEX TABLESPACE tablespace ] | CHECK (expression) | REFERENCES ref_table [ ( ref_column ) ] [ MATCH FULL | MATCH PARTIAL | MATCH SIMPLE ] [ ON DELETE action ] [ ...
修改一个数据库。 ALTERDATABASEnameSETparameter{TO|=}{value|DEFAULT}ALTERDATABASEnameRESETparameterALTERDATABASEnameRENAMETOnew_nameALTERDATABASEnameOWNERTOnew_owner 复制 ALTER DEFAULT PRIVILEGES 定义默认的访问权限。 ALTERDEFAULTPRIVILEGES[FOR{ROLE|USER}target_role[,...]][INSCHEMAschema_name[,...]]ab...
[MATCH FULL | MATCH PARTIAL | MATCH SIMPLE][ON DELETE referential_action][ON UPDATE referential_action]}[DEFERRABLE | NOT DEFERRABLE][INITIALLY DEFERRED | INITIALLY IMMEDIATE]andtable_constraintis:[CONSTRAINT constraint_name]{CHECK( expression )[NO INHERIT]|UNIQUE[NULLS [ NOT]DISTINCT] ( column_...
\da 列出所有可用聚集. \dd object 列出pg_description 里对声明的对象的描述,对象可以是一个表,表中的列/字段,类型,操作符或聚集. 小技巧:并非所有对象在 pg_description 里有描述.此后期命令在快速获取 Postgres 内部特性时很有用. \df 列出函数. ...
一、PostgreSQL语法 1.1 SQL 语句 一个SQL 语句通常包含了关键字、标识符(字段)、常量、特殊符号等,下面是一个简单的 SQL 语句: SELECT id, name FROM runoob 1. 1.2 PostgreSQL 命令 ABORT ABORT 用于退出当前事务。 ABORT [ WORK | TRANSACTION ]
139. [ MATCH FULL | MATCH PARTIAL| MATCH SIMPLE ][ ON DELETE action ] [ ON UPDATE action ] } 140. [ DEFERRABLE |NOT DEFERRABLE ][ INITIALLY DEFERRED | INITIALLY IMMEDIATE ] 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12.
LIKE –Find a string that match a pattern. Regular Expressions –Learn how to use match operator (~) to search for strings that match POSIX regular expressions. SIMILAR TO –Search for a string that matches a pattern containing wildcard characters (% and _ ) or regular expression. Full-text...
WHEN'p'THEN'PARTIAL' ENDASmatch_type, t2.relname ASreferences_table, array_to_string(c.confkey, ' ') ASfk_constraint_key FROMpg_constraint c LEFTJOINpg_class t ONc.conrelid = t.oid LEFTJOINpg_class t2 ONc.confrelid = t2.oid ...