How To Check All Data Schema Table On Postgresql

how to check all data schema table on postgresql


SELECT *
FROM information_schema.columns
WHERE table_name = 'cv_marmer_2014';


---------------------------------------------
show all data tabel with query follow use query in here.

SELECT *
FROM information_schema.tables
ORDER BY table_schema,table_name;

or

SELECT table_schema,table_name
FROM information_schema.tables
ORDER BY table_schema,table_name;