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 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 Foster||Date: 2005-10-17 16:26:56|
|Subject: Determin if cascade is being used|
|Previous:||From: Martin Foster||Date: 2005-10-17 11:57:16|
|Subject: Re: Problems with query using aggregate functions|