Re: Porting from MySql - meta data issues

> 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.

Run psql with -E switch and you're able to see internal queries generated
by i.e. \dt and \l commands. Then you can cut'n'paste and modify those
queries to match your requirements.

-- 
Antti Haapala