检查postgresql中的列是否为增量列

SELECT 
    column_name, 
    column_default
FROM 
    information_schema.columns
WHERE 
    table_schema = 'your_schema' 
    AND table_name = 'your_table'
    AND column_default LIKE 'nextval%';

SELECT 
    a.attname AS column_name,
    d.adsrc AS default_value
FROM 
    pg_class c
JOIN 
    pg_attribute a ON a.attrelid = c.oid
JOIN 
    pg_attrdef d ON d.adrelid = c.oid AND d.adnum = a.attnum
WHERE 
    c.relname = 'your_table'
    AND a.attnum > 0
    AND d.adsrc LIKE 'nextval%';

SELECT 
    column_name,
    pg_get_serial_sequence('your_schema.your_table', column_name) AS sequence_name
FROM 
    information_schema.columns
WHERE 
    table_schema = 'your_schema' 
    AND table_name = 'your_table';

CREATE TABLE users (
    id SERIAL PRIMARY KEY,
    username VARCHAR(50) NOT NULL
);

SELECT 
    column_name, 
    column_default
FROM 
    information_schema.columns
WHERE 
    table_schema = 'public' 
    AND table_name = 'users'
    AND column_default LIKE 'nextval%';

SELECT 
    a.attname AS column_name,
    d.adsrc AS default_value
FROM 
    pg_class c
JOIN 
    pg_attribute a ON a.attrelid = c.oid
JOIN 
    pg_attrdef d ON d.adrelid = c.oid AND d.adnum = a.attnum
WHERE 
    c.relname = 'users'
    AND a.attnum > 0
    AND d.adsrc LIKE 'nextval%';

SELECT 
    column_name,
    pg_get_serial_sequence('public.users', column_name) AS sequence_name
FROM 
    information_schema.columns
WHERE 
    table_schema = 'public' 
    AND table_name = 'users';