Possible new feature

От

mgould

Тема

Дата

30 июля 2007 г. в 09:02:48

Msg-id

20070730120229.f24af0db@mail.allcoast.net

обсуждение

Список

pgsql-general

Дерево обсуждения

Possible new feature mgould <mgould@allcoast.net> 30 июля 2007 г. в 09:02:48

Re: Possible new feature "Alexander Staubo" <alex@purefiction.net> 30 июля 2007 г. в 09:30:34

All,

I'm in the process of moving to PostGres from iAnywhere's SQL Anywhere v 10. One of the neat features from ASA 10 is the ability to create "proxy tables" These tables can be local or remote. The purpose of a proxy table is that once create it can be used just like any other table or view. You can use it in joins, subselects, etc. ASA sees it as just a normal table. The data can be stored in any ODBC compatible file system so it makes it easy to interact with all other database. The synatx is pretty simple :

CREATE EXISTING TABLE [owner.]table-name
[ (column-definition, ...) ]
AT location-string

column-definition :
column-name data-type [NOT NULL]

location-string :
remote-server-name.[db-name].[owner].object-name
| remote-server-name;[db-name];[owner];object-name

example:

CREATE EXISTING TABLE blurbs
( author_id ID not null,
copy text not null)
AT 'server_a.db1.joe.blurbs';

Now you can acces blurbs just like any table.

Best Regards,

Michael Gould

All Coast Intermodal Services Inc.

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

Предыдущее

От: Alban Hertroys