Re: External Database Connection

"Sean K. Sell" wrote:

> Has anyone successfully hacked an external database table as a view.
>
> I was thinking that this may be possible using a C function and the Rules architecture but I don't have much experience with PostgreSQL so I thought I
> would check with the list to see what if anything others had attempted.
>

Using C functions, you could probably do something like this:

create view dbname_table as select ext_query('select * from table', 'dbname'), extq_col_varchar('foo') as foo, extq_col_numeric('bar') as bar

It would not be a generic solution, but it could be done with today's sources.