Re: Switching from MySQL -- Missing DESCRIBE table, SHOW

From: Oliver Elphick <olly(at)lfix(dot)co(dot)uk>
To: Michael Glaesemann <grzm(at)myrealbox(dot)com>
Cc: Gan Uesli Starling <alias(at)starling(dot)us>, pgsql-novice(at)postgresql(dot)org
Subject: Re: Switching from MySQL -- Missing DESCRIBE table, SHOW
Date: 2005-10-17 13:03:55
Message-ID: 1129554236.8878.17.camel@linda.lfix.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Mon, 2005-10-17 at 08:56 +0900, Michael Glaesemann wrote:
> On Oct 17, 2005, at 8:31 , Gan Uesli Starling wrote:
...
> > Sorry to be over-verbose. The stress is on remote access via Perl/DBI
> > and XML-RPC. Those are my ONLY available routes. I do NOT have psql at
> > work...which is the problem.
> >
> > I have to submit ordinary SQL queries. In MySQL they had such queries,
> > namely the two stated above.
>
> If you read Oliver's response again, you'll see that he gave you a
> method to do this, namely, using the SQL-standard Information Schema.
> For more information on using the Information Schema in PostgreSQL, see
> http://www.postgresql.org/docs/8.0/interactive/information-schema.html

In addition, you can get exactly the information returned by \d by
entering the queries that psql submits. To find out what those are,
start psql with the -E option.

--
Oliver Elphick olly(at)lfix(dot)co(dot)uk
Isle of Wight http://www.lfix.co.uk/oliver
GPG: 1024D/A54310EA 92C8 39E7 280E 3631 3F0E 1EC0 5664 7A2F A543 10EA
========================================
Do you want to know God? http://www.lfix.co.uk/knowing_god.html

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Martin Foster 2005-10-17 16:26:56 Determin if cascade is being used
Previous Message Martin Foster 2005-10-17 11:57:16 Re: Problems with query using aggregate functions