Re: MySQLs Describe emulator!

From: Boulat Khakimov <boulat(at)inet-interactif(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-sql(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org
Subject: Re: MySQLs Describe emulator!
Date: 2001-03-06 14:14:54
Message-ID: 3AA4F0DE.D96BA904@inet-interactif.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-sql

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" ?

Hi,

1) "\d table" can only be used in psql, you cant run a query like that
using libpq for example

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.

Regards,
Boulat Khakimov

--
Nothing Like the Sun

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Holger Klawitter 2001-03-06 14:42:40 new tip feature
Previous Message Paulo Parola 2001-03-06 13:29:12 Reliable and up-to-date PostgreSQL virtual hosting suggestions

Browse pgsql-sql by date

  From Date Subject
Next Message Justin Long 2001-03-06 14:18:41 Re: Optimizing Query
Previous Message Markus Fischer 2001-03-06 12:33:23 Comparing dates