Skip to content

Instantly share code, notes, and snippets.

@roy-bukapeta

roy-bukapeta/sql

Created June 26, 2016 08:09
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save roy-bukapeta/6d0f9e03922086b6044e47a2a0a90602 to your computer and use it in GitHub Desktop.
Save roy-bukapeta/6d0f9e03922086b6044e47a2a0a90602 to your computer and use it in GitHub Desktop.
Download ZIP
update type data column nasionality
Raw
sql
ALTER TABLE participant ALTER COLUMN nationality TYPE integer USING (nationality::integer);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment