DBD::Pg tables() (was Re: ANNOUNCE: DBD::Pg 1.20)

[David Wheeler]

On Saturday, November 30, 2002, at 01:18  PM, Thomas A. Lowery wrote:

IMHO: a Pg only function is not a good option. It's very difficult to write
portable code.

Fair enough.

The DBI doc reads:
       "tables"
           Warning: This method is experimental and may change.

             @names = $dbh->tables( $catalog, $schema, $table, $type );
             @names = $dbh->tables;        # deprecated

<snip />

With the "table" method including catalog, schema, and type, I can see no reason to
exclude the system tables.

Well, since it appears that DBD::Pg's tables() method currently doesn't support the $catalog, $schema, $table, $type arguments, perhaps it should be updated to do so, and have the deprecated call to tables() with no args not return system tables.

Thoughts?

David

P.S.: PostgreSQL 7.3 support schemas, so the argument form of tables() may be more valuable than ever.

--
David Wheeler AIM: dwTheory
[EMAIL PROTECTED] ICQ: 15726394
http://david.wheeler.net/ Yahoo!: dew7e
Jabber: [EMAIL PROTECTED]