Find which tables 2 schemas differ (postgres)

SELECT tablename FROM pg_catalog.pg_tables WHERE schemaname='full_schema' EXCEPT SELECT tablename FROM pg_catalog.pg_tables WHERE schemaname='missing_tables_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.