List all tables in postgresql information_schema

sql postgresql information-schema
littleK picture littleK · Feb 16, 2010 · Viewed 377.9k times · Source

What is the best way to list all of the tables within PostgreSQL's information_schema?

To clarify: I am working with an empty DB (I have not added any of my own tables), but I want to see every table in the information_schema structure.

Answer

RodeoClown picture RodeoClown · Feb 16, 2010

You should be able to just run select * from information_schema.tables to get a listing of every table being managed by Postgres for a particular database.

You can also add a where table_schema = 'information_schema' to see just the tables in the information schema.

Related questions

How to check if a table exists in a given schema

Postgres 8.4 and greater databases contain common tables in public schema and company specific tables in company schema. company schema names always start with 'company' and end with the company number. So there may be schemas like: public company1 company2 company3 ... …

Read More
Finding columns that are NOT NULL in PostgreSQL

I had an assignment for each table to count nullable columns. Easy: SELECT table_name, count(*) FROM INFORMATION_SCHEMA.COLUMNS WHERE is_nullable='NO' GROUP BY table_name; Now I have to modify this to count "columns that have property "…

Read More
Behaviour of NOT LIKE with NULL values

I want to fetch all columns of a table except of columns of type serial. The closest query to this problem I was able to come up with this one: SELECT column_name FROM information_schema.columns WHERE table_name = …

Read More