postgres fdw create foreign table without specifiy columns

0 votes

1 answer

1355 views

                          need to create couple of foreign tables with a lot of columns from oracle.
I dont want to specify all cloumns by myself.
Is there a way to do something like this: 

    create foreign table ALFSTK **(*)** SERVER server1 options (schema 'test', table 'ALFSTK');

Or is this not possible with fdw?

Thanks for your advices.

Asked by MarcelS (19 rep)

Mar 9, 2020, 01:39 PM
Last activity: Mar 9, 2020, 10:09 PM

postgres fdw create foreign table without specifiy columns

Related Questions