By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE
| pg_get_serial_sequence |
|---|
| public.test_serialseq_serial_id_seq |
SELECT 1
| relname | relnamespace | reltype | reloftype | relowner | relam | relfilenode | reltablespace | relpages | reltuples | relallvisible | reltoastrelid | relhasindex | relisshared | relpersistence | relkind | relnatts | relchecks | relhasoids | relhaspkey | relhasrules | relhastriggers | relhassubclass | relrowsecurity | relforcerowsecurity | relispopulated | relreplident | relispartition | relfrozenxid | relminmxid | relacl | reloptions | relpartbound |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| test_serialseq_serial_id_seq | 2200 | 242469 | 0 | 242465 | 0 | 242468 | 0 | 1 | 1 | 0 | 0 | f | f | p | S | 3 | 0 | f | f | f | f | f | f | f | t | n | f | 0 | 0 | null | null | null |
SELECT 1
ALTER TABLE
| relname | relnamespace | reltype | reloftype | relowner | relam | relfilenode | reltablespace | relpages | reltuples | relallvisible | reltoastrelid | relhasindex | relisshared | relpersistence | relkind | relnatts | relchecks | relhasoids | relhaspkey | relhasrules | relhastriggers | relhassubclass | relrowsecurity | relforcerowsecurity | relispopulated | relreplident | relispartition | relfrozenxid | relminmxid | relacl | reloptions | relpartbound |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| test_serialseq_serial_id_seq | 2200 | 242469 | 0 | 242465 | 0 | 242468 | 0 | 1 | 1 | 0 | 0 | f | f | p | S | 3 | 0 | f | f | f | f | f | f | f | t | n | f | 0 | 0 | null | null | null |
| test_serialseq_serial_id_seq1 | 2200 | 242475 | 0 | 242465 | 0 | 242474 | 0 | 1 | 1 | 0 | 0 | f | f | p | S | 3 | 0 | f | f | f | f | f | f | f | t | n | f | 0 | 0 | null | null | null |
SELECT 2