Skip to content

Instantly share code, notes, and snippets.

@kythanh

kythanh/uuid_generate_v4.sql

Last active June 28, 2017 09:00
Show Gist options
  • Save kythanh/026d4c205ad454c9af227f109466d098 to your computer and use it in GitHub Desktop.
Save kythanh/026d4c205ad454c9af227f109466d098 to your computer and use it in GitHub Desktop.
Download ZIP
Using uuid_generate_v4() to generate GUID on PostgreSQL
Raw
uuid_generate_v4.sql
--1. First to enable the extention:
CREATE EXTENSION "uuid-ossp";
--2. Then Alter the PK column
alter table my_table alter column id set Default uuid_generate_v4();
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment