Re: All table names
| From: | Tomas V.V.Cox | Date: | Thu, 25 Oct 2001 00:29:39 +0000 |
| Subject: | Re: All table names | ||
| References: | 1 2 | Groups: | php.pear.general |
| Request: | Send a blank email to pear-general+get-419@lists.php.net to get a copy of this message | ||
Joao Prado Maia wrote:
>
> On Wed, 24 Oct 2001, Pablo DallOglio wrote:
>
> > Anyone knows how do I get all table names of database using Pear::DB ?
> >
>
> Just run a query for 'SHOW TABLES' on MySQL for instance. Every Database
> has its own way to show this information, so I guess it could be possible
> to add code on every driver for a 'showTables()' method.
>
> I'm not sure if this is desired though. Is PEAR::DB objective to do
> everything for the user of the class ? If so, this would be a good
> addition IMO.
>
Sure, it would be a great contribution. Let's take a look at Metabase or
ADODB? ;-)
Directly from phplib sources:
Oracle: SELECT table_name,tablespace_name FROM user_tables
PostgreSQL: select relname from pg_class where relkind = 'r' and not
relname like 'pg_%'
Tomas V.V.Cox