您现在的位置是：网站首页> 编程资料编程资料

PostgreSQL 序列绑定字段与不绑定字段的区别说明_PostgreSQL_

2023-05-27 399人已围观

简介 PostgreSQL 序列绑定字段与不绑定字段的区别说明_PostgreSQL_

序列绑定字段与不绑定字段的区别

绑定字段

构造数据

 drop sequence if exists test_id_seq; create sequence test_id_seq; drop table if exists test; create table test(id int default nextval('test_id_seq'), name text); alter sequence test_id_seq owned by test.id;

测试

 test=# drop table test; DROP TABLE test=# \d Did not find any relations. test=#

不绑定字段

构造数据

 drop sequence if exists test_id_seq; create sequence test_id_seq; drop table if exists test; create table test(id int default nextval('test_id_seq'), name text);

测试

 test=# drop table test; DROP TABLE test=# \d List of relations Schema | Name | Type | Owner --------+-------------+----------+---------- public | test_id_seq | sequence | postgres (1 row) test=#