Re: All table names
| From: | Pablo DallOglio | Date: | Thu, 25 Oct 2001 15:06:56 +0000 |
| Subject: | Re: All table names | ||
| References: | 1 2 3 4 | Groups: | php.pear.general |
| Request: | Send a blank email to pear-general+get-429@lists.php.net to get a copy of this message | ||
yes,
$TableNamesQuery['pgsql'] = "select tablename from pg_tables where tablename not
like 'pg%' order by tablename";
$TableNamesQuery['mysql'] = "SHOW TABLES";
$TableNamesQuery['oracle'] = "SELECT table_name FROM user_tables";
$TableNamesQuery['sybase'] = "select name from sysobjects where type = 'U'
order by name";
$TableNamesQuery['mssql'] = "select name from sysobjects where type = 'U'
order by name";
Can you mail-me when your changes will be done?
I can to prepare a new version of Agata.
Pablo Dall'Oglio
On Thu, 25 Oct 2001 17:01:10 +0200
"Tomas V.V.Cox" <cox@idecnet.com> wrote:
> On Thursday 25 October 2001 15:49, Pablo DallOglio wrote:
> > Now I still need to know table names on:
> >
> > FrontBase
> > InterBase
> > mssql
> > msql
> >
>
> Please could you send me the data you get? I'd be interested on adding
> this to Pear DB if you actually don't plan to contribute patches.
>
> Thanks,
>
> Tomas V.V.Cox
>
> --
> PEAR General Mailing List (http://pear.php.net/)
> To unsubscribe, e-mail: pear-general-unsubscribe@lists.php.net
> For additional commands, e-mail: pear-general-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net
--
Pablo Dall'Oglio
Linux User n. 223253