/* List all tables and other table info belonging to database 'demo'  */


SELECT  table_name, table_type                  # List all table info
FROM    information_schema.TABLES               # from TABLES
WHERE   table_schema  =  'public'               # belonging to db 'demo'