SELECT table_name FROM information_schema.tables WHERE table_schema = 'schema_with_more_tables'
EXCEPT SELECT table_name FROM information_schema.tables WHERE table_schema = 'schema_with_less_tables';
This Postgres query, mount one resultset with all tables which have in first schema and don't have in second schema.
Be the first to comment
You can use [html][/html], [css][/css], [php][/php] and more to embed the code. Urls are automatically hyperlinked. Line breaks and paragraphs are automatically generated.