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

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@lfix.co.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