# List PostgreSQL tables using extensions

DevFeed: [List PostgreSQL tables using extensions](<https://devfeed.tech/articles/list-postgresql-tables-using-extensions-34612.md>)

Original publisher: [Read original article](<https://tapoueh.org/blog/2019/11/list-postgresql-tables-using-extensions/>)

Author: Dimitri Fontaine PostgreSQL Major Contributor; Author

Published: 2019-11-12T17:30:00Z

Content type: tutorial

Language: en

Sources: [Dimitri Fontaine](<https://devfeed.tech/sources/dimitri-fontaine.md>)

Topics: [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [data type](<https://devfeed.tech/topics/data-type.md>), [Database](<https://devfeed.tech/topics/database.md>)

Tags: [data-type](<https://devfeed.tech/tags/data-type.md>), [database](<https://devfeed.tech/tags/database.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [query](<https://devfeed.tech/tags/query.md>), [schemas](<https://devfeed.tech/tags/schemas.md>)

## AI overview

A PostgreSQL query lists tables whose columns use data types provided by installed extensions. The article explains that the query scans the PostgreSQL catalog to identify those dependencies.

## Source excerpt

Postgres has extensions, and that's awesome! Of course as the author of CREATE EXTENSION I'm a little biased... just remember that the ability to extend Postgres is way more than just this command. The whole database system has been design from the ground up to allow for extensibility. Parts of the design is to be found in the way you can register new objects at runtime: functions of course, and also data types, operators, index support structures such as operator classes and families, even index access methods! Today's article shows a query that you can use to list those tables in your schemas that are using a data type which is provided by an extension.