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


Reply via email to