Re: Proposal to CREATE FOREIGN TABLE LIKE

Поиск
Список
Период
Сортировка
От Álvaro Herrera
Тема Re: Proposal to CREATE FOREIGN TABLE LIKE
Дата
Msg-id 202502011220.zky22md42obm@alvherre.pgsql
обсуждение исходный текст
Ответ на Proposal to CREATE FOREIGN TABLE LIKE  (Zhang Mingli <zmlpostgres@gmail.com>)
Ответы Re: Proposal to CREATE FOREIGN TABLE LIKE
Список 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

В списке pgsql-hackers по дате отправления: