| From: | Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at> |
|---|---|
| To: | "Ferrell, Denise CTR NSWCDD, Z11 *EXTERN*" <denise(dot)ferrell(dot)ctr(at)navy(dot)mil>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: ORACLE_FDW using a view |
| Date: | 2015-02-06 13:09:22 |
| Message-ID: | A737B7A37273E048B164557ADEF4A58B365969BF@ntex2010i.host.magwien.gv.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kieren Scott | 2015-02-06 14:08:11 | pg_createcluster failing on Trusty |
| Previous Message | akbar | 2015-02-05 07:49:52 | Re: PGPool II V3.3.3 and Jboss-7.2.0 |