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<nan_wich@bellsouth.net> 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: development-bounces@drupal.org [mailto:development-bounces@drupal.org]On Behalf Of Ivan Sergio Borgonovo Sent: Friday, September 04, 2009 4:42 PM To: development@drupal.org Subject: Re: [development] Postgres equivalent to SHOW TABLES
On Fri, 4 Sep 2009 15:56:41 -0400 "Nancy Wichmann" <nan_wich@bellsouth.net> 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