From: | Geoff Caplan <geoff(at)advantae(dot)com> |
---|---|
To: | Postgres General List <pgsql-general(at)postgresql(dot)org> |
Subject: | Porting from MySql - meta data issues |
Date: | 2002-04-04 20:14:07 |
Message-ID: | 5.1.0.14.0.20020404203520.00ab7c80@pop.dsl.pipex.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi folks
I'm porting quite a big PHP application from MySql and have hit an issue.
I have a number of PHP functions in the app which return meta-info about
the data structure:
list_databases( ) ;
list_tables( $database_name ) ;
list_field_names( $table_name ) ;
is_existing_field( $table_name ) ;
With MySql, this info is readily available using the various SHOW queries,
but I can't figure out how to do this with Postgres.
The only option I have come up with is to shell out to psql, run \l and \d
commands, and use a regex to parse the strings returned. Clearly, this
would be a bit of a hack, and not resource efficient.
Can any kind person suggest a more effective approach? I am brand new to
Postgres, and doing this under considerable time pressure, so apologies if
I am missing anything obvious - I can't find anything in the docs, or in
the articles on porting from MySQL...
Geoff Caplan
Advantae Ltd
From | Date | Subject | |
---|---|---|---|
Next Message | Command Prompt, Inc. | 2002-04-04 20:26:33 | Announce: SSL-ODBC Available |
Previous Message | Helge Bahmann | 2002-04-04 19:49:39 | Re: Update to readline and Postgresql |