Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2004
    Posts
    1

    Unanswered: Query Oracle tables from PL/pgSQL database

    Hi,

    I want to create a PostGres PL/pgSQL function which will query some oracle tables on a remote Oracle database, and write results on the PostGres database.
    Is there any way to do it from PL/pgSQL ?
    Does PostGresSql recognizes Database Links?
    Can I create a Synonym in PostGres poiting to an remote Oracle database table?

    Thank you,

  2. #2
    Join Date
    Sep 2001
    Location
    Vienna
    Posts
    400

    Synonym

    I don't think so but you can connect to an oracle database with this method


    with a dblink connector to oracle

    But this is commercial
    www.cybertec.at
    http://www.postgresql.org
    --Postgresql is the only kind of thing--

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •