CREATE SEQUENCE test.my_seq01
INCREMENT BY 1
MINVALUE 1
MAXVALUE 2147483647
START 1
CACHE 1
NO CYCLE;

SELECT
*
FROM information_schema.sequences
WHERE sequence_schema = 'test'
AND sequence_name = 'my_seq01'
order by sequence_name ;

ALTER SEQUENCE test.my_seq01 MAXVALUE 9223372036854775807 ;

SELECT nextval('my_seq01'); 

SELECT currval('my_seq01');

SELECT setval('my_seq01', 2000);

ALTER SEQUENCE my_seq01 RESTART WITH 2000;

CREATE TABLE "test"."my_table01"
(
id  bigint not null default nextval('my_seq01'),
name text,
CONSTRAINT "my_table01_pkey" PRIMARY KEY ("id")
);

INSERT INTO "test"."my_table01"("name") VALUES('kate'),('wangwei'),('liuyang') ;

SELECT * FROM "test"."my_table01" ;

CREATE TABLE "test"."my_table02"
(
id  bigint not null,
name text,
CONSTRAINT "my_table02_pkey" PRIMARY KEY ("id")
);

ALTER TABLE "test"."my_table02"  ALTER COLUMN id SET DEFAULT nextval('my_seq01');

WITH column_sequence AS (
SELECT
table_schema,
table_name,
column_name,
substr(column_default, 10, length(column_default) - 21) AS sequence_name
FROM information_schema.columns
WHERE column_default LIKE 'nextval%'
)
SELECT
cs.table_name,
cs.column_name,
s.sequence_catalog,
s.sequence_schema,
s.sequence_name,
s.data_type,
s.start_value,
s.minimum_value,
s.maximum_value,
s.increment,
s.cycle_option
FROM information_schema.sequences s
JOIN column_sequence cs ON s.sequence_schema = cs.table_schema AND s.sequence_name = cs.sequence_name
WHERE sequence_catalog = 'gufen'
AND sequence_schema = 'middle'
ORDER BY cs.table_name, cs.column_name,s.sequence_name;