Re: ORACLE_FDW using a view

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

-- 
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin





[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux