Catalog Queries

List PostgreSQL Extension Objects with pg_describe_object You ran CREATE EXTENSION fuzzystrmatch, and before you move, dump or drop it you need to know what it put in the database. In psql, \dx+ fuzzystrmatch lists every object that belongs to the extension. That command runs one query against pg_depend. The query …