Skip to content

Instantly share code, notes, and snippets.

@kad1r

kad1r/postgres_conversion_example.sql

Created October 2, 2023 13:48
Show Gist options
  • Save kad1r/b3876e979076d4222d3b2a99a1b9aa38 to your computer and use it in GitHub Desktop.
Save kad1r/b3876e979076d4222d3b2a99a1b9aa38 to your computer and use it in GitHub Desktop.
Download ZIP
Postgres string to bigint conversion example by USING column_name:bigint
Raw
postgres_conversion_example.sql
ALTER TABLE the_table ALTER COLUMN col_name TYPE integer USING (col_name::integer);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment