Skip to content

Instantly share code, notes, and snippets.

@athiwatp

athiwatp/oracle_check_column_exists.sql

Forked from drawcode/oracle_check_column_exists.sql
Created March 6, 2019 08:53
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save athiwatp/d7358dbfe97132fdac36386740392a0f to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save athiwatp/d7358dbfe97132fdac36386740392a0f to your computer and use it in GitHub Desktop.
Download ZIP
Check if column exists on table in PGSQL
Raw
oracle_check_column_exists.sql
select table_name from user_tab_columns
where table_name = myTable and column_name = myColumn;
Raw
pgsql_check_column_exists.sql
SELECT column_name
FROM information_schema.columns
WHERE table_name='your_table' and column_name='your_column';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment