Skip to content

Instantly share code, notes, and snippets.

View ludwinas's full-sized avatar

Laura Macchini ludwinas

View GitHub Profile
@ludwinas
ludwinas / enum.sql
Last active November 1, 2018 10:19
Renaming an ENUM value in Postgres 9.5
-- assuming your existing type is as follows
CREATE TYPE user_types AS ENUM
( 'user',
'admin',
'foo'
);
-- here's how you rename the 'foo' value to 'bar'
BEGIN;

Keybase proof

I hereby claim:

  • I am ludwinas on github.
  • I am ludwinas (https://keybase.io/ludwinas) on keybase.
  • I have a public key ASCT0_dAuiUvjzU0i5uHHLPcBfH3L3PhHzTz3rk3CXav4Ao

To claim this, I am signing this object: