[development] Postgres equivalent to SHOW TABLES
damz at prealable.org
Fri Sep 4 23:12:36 UTC 2009
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
On Sat, Sep 5, 2009 at 12:50 AM, Nancy Wichmann<nan_wich at 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
> Nancy E. Wichmann, PMP
> Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King,
> -----Original Message-----
> From: development-bounces at drupal.org
> [mailto:development-bounces at drupal.org]On Behalf Of Ivan Sergio
> Sent: Friday, September 04, 2009 4:42 PM
> To: development at drupal.org
> Subject: Re: [development] Postgres equivalent to SHOW TABLES
> On Fri, 4 Sep 2009 15:56:41 -0400
> "Nancy Wichmann" <nan_wich at 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.
> 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
> 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
More information about the development