Skip to content

Instantly share code, notes, and snippets.

@drawcode

drawcode/oracle_check_column_exists.sql

Last active March 23, 2023 08:18
Show Gist options
  • Star 4 You must be signed in to star a gist
  • Fork 1 You must be signed in to fork a gist
  • Save drawcode/4441656 to your computer and use it in GitHub Desktop.
Save drawcode/4441656 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