Re: [GENERAL] Connection to second database on server

2008-08-24 Thread Troy Rasiah
Scott Marlowe wrote: > On Sun, Aug 24, 2008 at 10:19 PM, Troy Rasiah <[EMAIL PROTECTED]> wrote: >> >> Scott Marlowe wrote: >>> On Sun, Aug 24, 2008 at 8:43 PM, Troy Rasiah <[EMAIL PROTECTED]> wrote: Sorry for bringing up an old post...If you have a generic set of tables.. eg. table

Re: [GENERAL] Connection to second database on server

2008-08-24 Thread Scott Marlowe
On Sun, Aug 24, 2008 at 10:19 PM, Troy Rasiah <[EMAIL PROTECTED]> wrote: > > > Scott Marlowe wrote: >> On Sun, Aug 24, 2008 at 8:43 PM, Troy Rasiah <[EMAIL PROTECTED]> wrote: >>> Sorry for bringing up an old post...If you have a generic set of tables.. >>> >>> eg. table of countries / post codes et

Re: [GENERAL] Connection to second database on server

2008-08-24 Thread Troy Rasiah
Scott Marlowe wrote: > On Sun, Aug 24, 2008 at 8:43 PM, Troy Rasiah <[EMAIL PROTECTED]> wrote: >> Sorry for bringing up an old post...If you have a generic set of tables.. >> >> eg. table of countries / post codes etc which are used across several >> databases what is the best way to access / sto

Re: [GENERAL] Connection to second database on server

2008-08-24 Thread Scott Marlowe
On Sun, Aug 24, 2008 at 8:43 PM, Troy Rasiah <[EMAIL PROTECTED]> wrote: > > Sorry for bringing up an old post...If you have a generic set of tables.. > > eg. table of countries / post codes etc which are used across several > databases what is the best way to access / store them? > I currently > -

Re: [GENERAL] Connection to second database on server

2008-08-24 Thread Troy Rasiah
Hermann Muster wrote: > Bill Moran wrote: >> In response to Hermann Muster <[EMAIL PROTECTED]>: >> >> >>> Hello everyone, >>> >>> I already asked about that a couple of days ago, but didn't get an >>> satisfying solution for my problem which is following: >>> >>> I need to create a view that

Re: [GENERAL] Connection to second database on server

2008-07-03 Thread Scott Marlowe
On Thu, Jul 3, 2008 at 7:29 AM, Hermann Muster <[EMAIL PROTECTED]> wrote: > > I just found the time to try that out and it worked! Thank you for your > help. I actually had no idea about using schemas in PostgreSQL. It was easy > to setup and db_link isn't needed anymore. I hope I won't run into an

Re: [GENERAL] Connection to second database on server

2008-07-03 Thread Hermann Muster
Bill Moran wrote: In response to Hermann Muster <[EMAIL PROTECTED]>: Hello everyone, I already asked about that a couple of days ago, but didn't get an satisfying solution for my problem which is following: I need to create a view that does a query on a second database on the same Postg

Re: [GENERAL] Connection to second database on server

2008-06-20 Thread Scott Marlowe
On Fri, Jun 20, 2008 at 8:06 AM, Bill Moran <[EMAIL PROTECTED]> wrote: > In response to Hermann Muster <[EMAIL PROTECTED]>: > >> Hello everyone, >> >> I already asked about that a couple of days ago, but didn't get an >> satisfying solution for my problem which is following: >> >> I need to create

Re: [GENERAL] Connection to second database on server

2008-06-20 Thread Bill Moran
In response to Hermann Muster <[EMAIL PROTECTED]>: > Hello everyone, > > I already asked about that a couple of days ago, but didn't get an > satisfying solution for my problem which is following: > > I need to create a view that does a query on a second database on the > same PostgreSQL serve

Re: [GENERAL] Connection to second database on server

2008-06-20 Thread Julius Tuskenis
Hi, Hermann. The best solution in my opinion would be using users name and password to connect to database. That way you can decide (grant) what tables can be accessed by this user and there is no password you have to hide from him (or others). So use stored procedure returning set of records

[GENERAL] Connection to second database on server

2008-06-20 Thread Hermann Muster
Hello everyone, I already asked about that a couple of days ago, but didn't get an satisfying solution for my problem which is following: I need to create a view that does a query on a second database on the same PostgreSQL server. dblink seems to be the only (???) solution for doing so. The