Skip to content

Instantly share code, notes, and snippets.

@camsaul

camsaul/select_tables_by_name.psql

Created October 3, 2014 23:16
Show Gist options
  • Save camsaul/23ec803ce517e072abe3 to your computer and use it in GitHub Desktop.
Save camsaul/23ec803ce517e072abe3 to your computer and use it in GitHub Desktop.
Download ZIP
Postgres select tables by name
Raw
select_tables_by_name.psql
SELECT table_name
FROM information_schema.tables
WHERE table_name LIKE 'prefix_%';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment