information_schema is supported by both PostgreSQL and Mysql, with some subtle differences.
Drupal 6 doesn't have any schema querying features, so I suggest you open a feature request to the schema module, and rely on it for your needs. Damien Tournoud On Sat, Sep 5, 2009 at 12:50 AM, Nancy Wichmann<[email protected]> wrote: > Ivan Sergio Borgonovo wrote: >> So you connect to postgresql through psql -E > > I guess I haven't been clear. I am writing a module and want it to be able > to support both MySql and Postgres. This will be in the code. I don't have > Postgres. > > Nancy E. Wichmann, PMP > Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King, > Jr. > > > -----Original Message----- > From: [email protected] > [mailto:[email protected]]on Behalf Of Ivan Sergio > Borgonovo > Sent: Friday, September 04, 2009 4:42 PM > To: [email protected] > Subject: Re: [development] Postgres equivalent to SHOW TABLES > > > On Fri, 4 Sep 2009 15:56:41 -0400 > "Nancy Wichmann" <[email protected]> wrote: > >> Ivan Sergio Borgonovo wrote: >> > start psql with -E param ... >> >> This is in a module, so I cannot demand that the user start it any >> way other than how it would be started for Drupal. > > That's just to learn how to get the information with SQL. > > So you connect to postgresql through psql -E > use \d stuff > get the SQL used by psql to get the info and copy and paste it in > your drupal module. > > Actually this is not going to be portable. > A better way would be to learn how to query information_schema that > *should* be portable. > > information_schema should be in the sql-92 standard. > > http://dev.mysql.com/doc/refman/5.0/en/information-schema.html > http://www.postgresql.org/docs/8.1/interactive/information-schema.html > http://www.ocelot.ca/is.htm > > I think that in postgresql information_schema is just a view on the > internal format that should reside in pg_catalog. schema. > > -- > Ivan Sergio Borgonovo > http://www.webthatworks.it > > No virus found in this incoming message. > Checked by AVG - www.avg.com > Version: 8.5.409 / Virus Database: 270.13.73/2338 - Release Date: 09/04/09 > 05:51:00 > >
