Re: ORACLE_FDW using a view - Mailing list pgsql-admin

From Albe Laurenz
Subject Re: ORACLE_FDW using a view
Date
Msg-id A737B7A37273E048B164557ADEF4A58B365969BF@ntex2010i.host.magwien.gv.at
Whole thread Raw
In response to ORACLE_FDW using a view  ("Ferrell, Denise CTR NSWCDD, Z11" <denise.ferrell.ctr@navy.mil>)
List pgsql-admin
Denise Ferrell wrote:
> Running PostgreSQL 9.3 on a Linux Red-Hat 6 platform.  Downloaded oracle_fdw v1.0.0.
> 
> Is there another version of this extension that will allow for selection using a view instead of a
> table?

I am not totally certain what you mean.

You can create a foreign table that points to an Oracle view.
You can create a PostgreSQL view based on a foreign table.

Both should work fine.
Do you have a specific problem?

Yours,
Laurenz Albe

pgsql-admin by date:

Previous
From: akbar
Date:
Subject: Re: PGPool II V3.3.3 and Jboss-7.2.0
Next
From: Kieren Scott
Date:
Subject: pg_createcluster failing on Trusty