um_permissions.sql

gistfile1.txt

SELECT id, name, display_name, description, created_at, updated_at
	FROM unittrust.um_permissions;

SELECT Max(id)FROM unittrust.um_permissions;
SELECT *FROM unittrust.um_permissions
WHERE name LIKE  '%system-modules%';

ALTER SEQUENCE um_mod_permissions_id_seq RESTART WITH 1;
ALTER SEQUENCE um_permissions_id_seq RESTART WITH 1;

SET search_path TO unittrust;
ALTER SEQUENCE um_roles_id_seq RESTART WITH 1;

1. For a non-existing column

-- auto-increment constraint for a new column
ALTER TABLE public.products
ADD COLUMN id SERIAL PRIMARY KEY;

-- create sequence

2. For an existing column that got no values in the table

CREATE SEQUENCE public_products_id_seq OWNED BY public.products.id;

-- use sequence for the target column
ALTER TABLE public.products ALTER COLUMN id SET DEFAULT nextval('public_products_id_seq');

3. For an existing column that already got some values in the table

-- create sequence
CREATE SEQUENCE public_products_id_seq OWNED BY public.products.id;

-- set the current value of the sequence to the max value from that column
-- (id column in this scenario)
SELECT SETVAL('public_products_id_seq', (select max(id) from public.products), false)

-- use sequence for the target column
ALTER TABLE public.products ALTER COLUMN id SET DEFAULT nextval('public_products_id_seq');

https://dba.stackexchange.com/questions/78732/change-existing-column-in-pg-to-auto-incremental-primary-key