src/test/regress/expected/pg_dump_binary_upgrade.out

-- Ensure that pg_dump --binary-upgrade correctly outputs
-- ALTER TABLE DROP COLUMN DDL for external tables.
CREATE SCHEMA dump_this_schema;
-- External tables with dropped columns is dumped correctly.
CREATE EXTERNAL TABLE dump_this_schema.external_table_with_dropped_columns (
    a int,
    b int,
    c int
) LOCATION ('gpfdist://1.1.1.1:8082/xxxx.csv') FORMAT 'csv';
ALTER EXTERNAL TABLE dump_this_schema.external_table_with_dropped_columns DROP COLUMN a;
ALTER EXTERNAL TABLE dump_this_schema.external_table_with_dropped_columns DROP COLUMN b;
-- Run pg_dump and expect to see an ALTER TABLE DROP COLUMN output
-- for the tables with dropped column references.
\! pg_dump --binary-upgrade --schema dump_this_schema regression | grep " DROP COLUMN "
ALTER FOREIGN TABLE ONLY dump_this_schema.external_table_with_dropped_columns DROP COLUMN "........pg.dropped.1........";
ALTER FOREIGN TABLE ONLY dump_this_schema.external_table_with_dropped_columns DROP COLUMN "........pg.dropped.2........";
DROP SCHEMA dump_this_schema CASCADE;
NOTICE:  drop cascades to foreign table dump_this_schema.external_table_with_dropped_columns