On 2025-Feb-01, Zhang Mingli wrote: > Our DBA team uses foreign tables for ETL processes in Greenplum and > Cloudberry, > and we often need to create foreign tables that match the column definitions > of local tables. > > When dealing with wide tables and lots of those foreign tables, it can get > pretty tedious and mistakes happen easily.
Sure. Did you consider IMPORT FOREIGN SCHEMA? -- Álvaro Herrera 48°01'N 7°57'E — https://www.EnterpriseDB.com/ […] indem ich in meinem Leben oft an euch gedacht, euch glücklich zu machen. Seyd es! A menudo he pensado en vosotros, en haceros felices. ¡Sedlo, pues! Heiligenstädter Testament, L. v. Beethoven, 1802 https://de.wikisource.org/wiki/Heiligenstädter_Testament