Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group