Re: Couple simple(?) questions...

Поиск
Список
Период
Сортировка
Искать
От
GH
Тема
Re: Couple simple(?) questions...
Дата
Msg-id
20001125213733.D39544@over-yonder.net
Ответ на
Список
Дерево обсуждения
Re: Couple simple(?) questions... Ron Chmara <ron@Opus1.COM>
Re[2]: Couple simple(?) questions... Dmitri Touretsky <dmitri@listsoft.ru>
Re: Couple simple(?) questions... GH <grasshacker@over-yonder.net>
On Sat, Nov 25, 2000 at 08:11:31PM -0700, some SMTP stream spewed forth: 
> Dmitri Touretsky wrote:
> > 1. Is it possible to SELECT from two databases? Something like
> >    SELECT db1.table1.field, db2.table1.fields ...
> 
> No. So I use the following table naming convention:
> dbname1_tablename1
> dbname1_tablename2
> ...
> dbname1_tablename5
> dbname2_tablename1
> dbname2_tablename2
> ...
> dbname2_tablename5
> 
> This provides me with easier logical groupings.

Yes, but removes any "physical" seperation of the db1 and db2 tables.
e.g. You would have to resort to some trickery to backup only one set of
tables. My point being simply to affirm that such a "feature" would be 
very much welcomed -- as I believe it is in 7.1.(?)

> 

*snip* 

gh

В списке pgsql-novice по дате отправления
От: Ron Chmara
Дата:
От: Tom Lane
Дата:
FAQ