Make sure that you do not drop INFORMATION_SCHEMA schema. In this case most of the design checking queries will not work. This schema automatically exists in all databases.
Type
Problem detection (Each row in the result could represent a flaw in the design)
Make the dump of the database, create a new database, and restore your database objects and data based on the dump in the new database.
Data Source
INFORMATION_SCHEMA+system catalog
SQL Query
SELECT 'INFORMATION_SCHEMA has been deleted' AS comment
WHERE NOT EXISTS (SELECT *
FROM pg_namespace AS n INNER JOIN pg_authid AS a ON n.nspowner=a.oid
WHERE (n.nspname='information_schema' AND a.rolname='postgres'));
Collections
This query belongs to the following collections:
Name
Description
Find problems automatically
Queries, that results point to problems in the database. Each query in the collection produces an initial assessment. However, a human reviewer has the final say as to whether there is a problem or not .
Categories
This query is classified under the following categories:
Name
Description
Schemas
Queries of this category provide information about databse schemas