Skip to content

Instantly share code, notes, and snippets.

@MbuguaCaleb

MbuguaCaleb/gist:77ae0fbf49da131124882185f69b4504

Created March 17, 2021 11:38
Show Gist options
  • Save MbuguaCaleb/77ae0fbf49da131124882185f69b4504 to your computer and use it in GitHub Desktop.
Save MbuguaCaleb/77ae0fbf49da131124882185f69b4504 to your computer and use it in GitHub Desktop.
Download ZIP
um_permissions.sql
Raw
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;
@MbuguaCaleb
Copy link
Author

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment