Skip to content

Instantly share code, notes, and snippets.

@arowla

arowla/Find tables containing a column name in PostgreSQL

Created June 17, 2010 18:43
Show Gist options
  • Save arowla/442552 to your computer and use it in GitHub Desktop.
Save arowla/442552 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Find tables containing a column name in PostgreSQL
SELECT table_schema, table_name FROM information_schema.columns WHERE column_name LIKE '%name%';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment