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: (view raw, whole thread or download thread mbox)
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

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                    
GPG: 1024D/A54310EA  92C8 39E7 280E 3631 3F0E  1EC0 5664 7A2F A543 10EA
   Do you want to know God?

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-2017 The PostgreSQL Global Development Group