test123

 SELECT n.nspname AS schema_name, c.relname AS sequence_name FROM pg_class c JOIN pg_namespace n ON n.oid = c.relnamespace WHERE c.relkind = 'S' -- 'S' indicates a sequence AND c.relname = 'your_sequence_name';

SELECT 

    n.nspname AS schema_name,

    c.relname AS object_name,

    CASE c.relkind

        WHEN 'r' THEN 'table'

        WHEN 'v' THEN 'view'

        WHEN 'S' THEN 'sequence'

        WHEN 'i' THEN 'index'

        ELSE c.relkind::text

    END AS object_type

FROM 

    pg_class c

JOIN 

    pg_namespace n ON n.oid = c.relnamespace

WHERE 

    c.relname = 'your_object_name';  -- Replace with your table/view/sequence name

SELECT 

    table_schema,

    table_name,

    column_name,

    column_default

FROM 

    information_schema.columns

WHERE 

    column_default LIKE 'nextval(%user_id_seq%)';