Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2002
    Posts
    17

    Unanswered: Selecting Data from a different database than you current one

    If I am in database A and want to query data from database B what database notation do I use? I cannot seem to find a reference for this.

    In MSSQL it is databasename.dbo.table

    thanks

    Dave
    David Williams
    Senior Jack of All Trades

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

    dblink

    I think what you need is dblink.

    You want to make joins through databases.
    It's in the contrib of postgres
    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
  •