Skip to content

Instantly share code, notes, and snippets.

@fabiolimace

fabiolimace/find_database_objects.sql

Created June 12, 2020 12:53
Show Gist options
  • Save fabiolimace/0f10726b8d0643670590709b009c6974 to your computer and use it in GitHub Desktop.
Save fabiolimace/0f10726b8d0643670590709b009c6974 to your computer and use it in GitHub Desktop.
Download ZIP
Find database objects on PostgreSQL
Raw
find_database_objects.sql
-- Find table
SELECT table_schema, table_name
FROM information_schema.tables
WHERE table_type='BASE TABLE'
AND table_name ILIKE '%tablename%';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment