Cheat Code for Database Meta information : PostgreSql

In an earlier post we looked at the Queries for Sql Server for retrieving meta information. In this post, we will look at the PostgresSql version. Get All Views SELECT table_name, view_definition FROM information_schema.VIEWS WHERE table_schema = ANY ( Current_schemas(FALSE) ); Get All Tables SELECT table_name FROM information_schema.TABLES WHERE table_schema = ANY ( Current_schemas(FALSE) ) Get All … Continue reading Cheat Code for Database Meta information : PostgreSql