Re: Proposal to CREATE FOREIGN TABLE LIKE - Mailing list pgsql-hackers

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