Skip to content

Instantly share code, notes, and snippets.

@ryanpadilha

ryanpadilha/postgresql-verify-object.sql

Created November 22, 2017 16:04
Show Gist options
  • Save ryanpadilha/f794f8744f87356f915e6f9476b695b4 to your computer and use it in GitHub Desktop.
Save ryanpadilha/f794f8744f87356f915e6f9476b695b4 to your computer and use it in GitHub Desktop.
Download ZIP
Useful commands for search objects on postgresql
Raw
postgresql-verify-object.sql
psql -h 172.31.3.119 -U <username> -p 5492 <database>
\dt public.*
select * from pg_tables where schemaname='public';
SELECT specific_catalog, specific_schema, specific_name, routine_name
FROM information_schema.routines
WHERE routine_type='FUNCTION'
AND specific_schema='public'
AND routine_name LIKE 'gin_%';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment