Skip to content

Instantly share code, notes, and snippets.

@ricardodantas

ricardodantas/postgresql_uuid.sql

Last active February 10, 2020 13:24
Show Gist options
  • Save ricardodantas/3c6efa939551c9fdf0c1fe591f3f5f69 to your computer and use it in GitHub Desktop.
Save ricardodantas/3c6efa939551c9fdf0c1fe591f3f5f69 to your computer and use it in GitHub Desktop.
Download ZIP
Using uuid postgresql
Raw
postgresql_uuid.sql
-- https://stackoverflow.com/questions/20342717/postgresql-change-column-type-from-int-to-uuid
CREATE EXTENSION IF NOT EXISTS "uuid-ossp";
ALTER TABLE tableA ALTER COLUMN colA SET DATA TYPE UUID USING (uuid_generate_v4());
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment