1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
|
# name: test/sql/pg_catalog/pg_constraint.test
# description: Test pg_constraint function
# group: [pg_catalog]
query IIIIII nosort pg_constraint
SELECT * FROM pg_constraint
statement ok
create table a (id int , primary key (id));
statement ok
create table b (id int , foreign_a int, foreign key (foreign_a) references a);
statement ok
insert into a (id) values (0);
statement ok
insert into b (id, foreign_a) VALUES (0, 0);
query IIIIIIIIIIIIIIIIIIIIII
SELECT * EXCLUDE (OID, CONRELID, connamespace) FROM pg_catalog.pg_constraint
----
PRIMARY KEY(id) p false false true 0 0 0 0 NULL NULL NULL true 0 false [0] NULL NULL NULL NULL NULL NULL
NOT NULL x false false true 0 0 0 0 NULL NULL NULL true 0 false [0] NULL NULL NULL NULL NULL NULL
FOREIGN KEY (foreign_a) REFERENCES a(id) f false false true 0 0 0 0 NULL NULL NULL true 0 false [1] NULL NULL NULL NULL NULL NULL
|
