Exforsys

Online Training

Query with Querying Database

This is a discussion on Query with Querying Database within the MySQL forums, part of the Database category; I am using PostgreSQL for the past few months. Now I am faced with a problem.I want to query ...


Go Back   Exforsys > Database > MySQL

Query with Querying Database Query with Querying Database

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read

Reply

 

LinkBack Thread Tools
  #1 (permalink)  
Old 12-07-2006, 12:57 AM
Senior Member
  
Join Date: Apr 2006
Posts: 122
rachelle is on a distinguished road
Query with Querying Database
I am using PostgreSQL for the past few months. Now I am faced with a problem.I want to query a database other than the current one.Is it possible to query multiple databases using POSTGRE. How can I do that.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 05-11-2007, 03:41 PM
Senior Member
  
Join Date: Apr 2006
Posts: 125
ashlee is on a distinguished road
It is not possible for you to query multiple databases at the same time using POSTGRE. The reason being PostgreSQL does the loading of database by using database-specific system catalogs. If you still want to use multiple databases results I would suggest you to handle on the user interface side by making separate connections to each of these and then combining the results in the user interface side. But this approach would reduce your performance. So use this only if you need it very essential.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply

« Help in Query | Question 9 is the only one correct, rest of them syntax errors..Can anyone help me »

Thread Tools

Posting Rules
You may not post new questions
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads

Thread Thread Starter Forum Replies Last Post
How to find second max sal of employee with the co chandraismoon Oracle Tutorials 7 05-16-2008 03:08 AM
Comp.software-eng FAQ (Part 0): periodic postings and archives David Alex Lamb Tech FAQ 2 05-23-2004 05:15 AM
Comp.software-eng FAQ (Part 0): periodic postings and archives David Alex Lamb Tech FAQ 3 04-18-2004 05:15 AM
Kerberos FAQ, v2.0 (last modified 8/18/2000) Ken Hornstein Tech FAQ 0 04-17-2004 07:28 AM
[FAQ] FileMaker Pro - database for Macintosh and Windows Martin Trautmann Tech FAQ 0 04-17-2004 07:26 AM


All times are GMT -4. The time now is 04:29 PM.

Contact Us - Exforsys - Archive - Privacy Statement - Top

Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.1.0
Copyright 2004 - 2007 Exforsys Inc. All rights reserved.