Re: Withdraw PL/Proxy from commitfest

David Fetter wrote:
> DBI's DBD::Excel <http://search.cpan.org/~kwitknr/DBD-Excel-0.06/Excel.pm>
> is a more extreme example of this kind of thing. You can get connect
> strings that look like this:
>
> my $hDb = DBI->connect(
> "DBI:Excel:file=dbdtest.xls",
> undef,
> undef,
> {
> xl_vtbl => {
> TESTV => {
> sheetName => 'TEST_V',
> ttlRow => 5,
> startCol => 1,
> colCnt => 4,
> datRow => 6,
> datlmt => 4,
> }
> }
> }
> );
>
> That last bit with the hash of hashes of hashes is probably where we'd
> use CTEs to expand things out.

Or we could just leave the attribute dict as it is and use something like:

CREATE SERVER dbdtest FOREIGN DATA WRAPPER dbi
OPTIONS (
datasource 'DBI:Excel:file=dbdtest.xls',
attributes '{xl_vtbl => {TESTV => { ... } }}'
);

CREATE USER MAPPING FOR bob SERVER dbdtest
OPTIONS (username NULL, password NULL);

The connection lookup for "dbtest" (user bob) would return:

key value
----------- ------------------------------------------------------------
datasource DBI:Excel:file=dbdtest.xls
attributes {xl_vtbl => {TESTV => { ... } }}
username NULL
password NULL

Regards,
Martin