Re: Re: MySQLs Describe emulator!

From: Alfred Perlstein <bright(at)wintelcom(dot)net>
To: Boulat Khakimov <boulat(at)inet-interactif(dot)com>
Cc: Karel Zak <zakkr(at)zf(dot)jcu(dot)cz>, pgsql-sql(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org
Subject: Re: Re: MySQLs Describe emulator!
Date: 2001-03-06 15:29:45
Message-ID: 20010306072944.K8663@fw.wintelcom.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-sql

* Boulat Khakimov <boulat(at)inet-interactif(dot)com> [010306 07:24] wrote:
>
> Karel Zak wrote:
> > > On Tue, Mar 06, 2001 at 09:14:54AM -0500, Boulat Khakimov wrote:
> > > Tom Lane wrote:
> > > >
> > > > Boulat Khakimov <boulat(at)inet-interactif(dot)com> writes:
> > > > > Here is a nifty query I came up with
> > > > > that provides a detailed information on any row of any table.
> > > > > Something that is build into mySQL (DESC tablename fieldname)
> > > > > but not into PG.
> > > >
> > > > Er, what's wrong with psql's "\d table" ?
> > >
> > > 2) as a programmer I need to be able to find out as much info as
> > > possible about any given field
> > > which is what "describe" for in mySQL.
> >
> > As a programmer you can see psql source and directly found how SQL
> > query execute this tool. The PostgreSQL needn't non-standard statements
> > like MySQL's SHOW, DESC -- the postgreSQL has system catalogs.

FreeBSD has had some great successes because we're able to emulate
Linux, perhaps something in contrib or even the base system could
offer a MySQL compatibility module to help people ease into Postgresql
from Mysql?

--
-Alfred Perlstein - [bright(at)wintelcom(dot)net|alfred(at)freebsd(dot)org]

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Karel Zak 2001-03-06 15:37:32 Re: Re: MySQLs Describe emulator!
Previous Message Michelle Murrain 2001-03-06 15:29:23 Re: Re: MySQLs Describe emulator!

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2001-03-06 15:31:48 Re: Optimizing Query
Previous Message Michelle Murrain 2001-03-06 15:29:23 Re: Re: MySQLs Describe emulator!