Horton

Re: Proposal to CREATE FOREIGN TABLE LIKE

Alvaro Herrera <alvherre@alvh.no-ip.org>

View thread View on postgr.es
From: Álvaro Herrera <alvherre@alvh.no-ip.org>
To: Zhang Mingli <zmlpostgres@gmail.com>
Cc: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2025-02-01T12:20:17Z
Lists: 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

Commits

  1. Add support for LIKE in CREATE FOREIGN TABLE