Snippets

How to find table in PostgreSQL?

Replace <part_of_table_name> with table name you are looking for. Since query uses like you can just pass partial of table name. Note that pg_table_def only returns information about tables that are visible to the user, so if you haven’t found what you are looking for, it does not mean that table does not exist.