Skip to content

Instantly share code, notes, and snippets.

@slavamokerov

slavamokerov/search-by-description-postgres.sql

Last active October 15, 2017 15:37
Show Gist options
  • Save slavamokerov/f7b1d6a66a7e5cc05dae280f4f6f2850 to your computer and use it in GitHub Desktop.
Save slavamokerov/f7b1d6a66a7e5cc05dae280f4f6f2850 to your computer and use it in GitHub Desktop.
Download ZIP
Search by description. PostgreSQL
Raw
search-by-description-postgres.sql
select
objoid::regclass as tablename,
description as field_desc,
obj_description(objoid::regclass, 'pg_class') as table_desc
from pg_description
where description like 'sometext%'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment