Re: [pgadmin-support] How to provide db access to other systems

2006-07-04 Thread Keith C. Perry
Quoting "VivekanandaSwamy R." <[EMAIL PROTECTED]>: > > > > Hai keith, > I tried for this.I was creted and enabled this property and it appears > like below... > Type databaseuser > ipaddress method option > --

Re: [pgadmin-support] How to access table from one database to another database

2006-07-04 Thread Antoine
As an aside, Vivekananda, your questions (all of the recent ones) belong on the pgsql maillist and not on the pgadmin maillist and you shouldn't be emailing the pgadmin owner as well. And he probably shouldn't be posting html either! ;-) Antoine -- This is where I should put some witty comment

Re: [pgadmin-support] How to access table from one database to another database

2006-07-04 Thread Sim Zacks
I can think of numerous examples where someone might want to run a query against databases on different databases or servers. I don't think it has anything to do with design. You might think it is better to move the data together before running the query, but that takes a lot more time and effort

Re: [pgadmin-support] How to access table from one database to another database

2006-07-04 Thread Derrick Betts
You should never design a database structure that requires you to access a completely different database.  The best way to keep data separate, yet give your users access to the uniqueness of a separate structure, is to create different schemas.   You may wish to spend some time re-thinking th

Re: [pgadmin-support] How to access table from one database to another

2006-07-04 Thread Tino Wildenhain
VivekanandaSwamy R. schrieb: hi, I have 2 databases namee PAO and CAS. PAO contains 3 schemas named Public,pao,sts CAS contains 4 schemas named Public,cao,sts,reports Now i am in PAO database..now i want access table 'activity' in schema 'cas' in CAS database. How it is posible. Well, ac