View to other Tablespace?

Поиск
Список
Период
Сортировка
От Holger Mitterwald
Тема View to other Tablespace?
Дата
Msg-id Pine.HPP.3.95.980714103939.8042B-100000@hp00076.ina.de
обсуждение исходный текст
Список pgsql-sql
Hello,

I really do have a little bit a problem:
I have created a database and filled this with a huge amount of data. This
data is used in several applications. I don't like to copy the data to all
the other databases to use it in joins and I think it is waste of
diskspace anyway.
My idea was to create a view or a rule to "map" the tables to the other
databases.

Is this possible at all? How should this be done then?
Or is it possible to create a symbolic link on the filesystem to the
tablespace? (the data is used readonly) to get the same effect?

TNX

So long,
        Holger



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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: [SQL] SubQueries
Следующее
От: Kenneth Jacker
Дата:
Сообщение: #define in SQL?