Accessing a database form another database

Поиск
Список
Период
Сортировка
От Bill Thoen
Тема Accessing a database form another database
Дата
Msg-id 4A804F4A.50300@gisnet.com
обсуждение исходный текст
Ответы Re: Accessing a database form another database  (David Fetter <david@fetter.org>)
Re: Accessing a database form another database  (Guy Rouillier <guyr-ml1@burntmail.com>)
Список pgsql-general
I've got some GIS tables that I want to use across several projects and
currently I've got each project in a separate database. So say I've got
two databases, one for the Spacely Sprookets project and one for the
Cogswell Cogs contract, but I want to access my WorldMap tables in my
GIS database to make maps for both of these projects.  How do I
reference a table that's in another database? Or should I organize my
PostgreSQL data differently?

Thanks,
- Bill Thoen


В списке pgsql-general по дате отправления:

Предыдущее
От: Juan Backson
Дата:
Сообщение: PQstatus does not seem to work
Следующее
От: John R Pierce
Дата:
Сообщение: Re: NOTICE: there is no transaction in progress