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

Re: Explain with schema

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: cunha17(at)gmail(dot)com
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Explain with schema
Date: 2011-01-26 19:39:27
Message-ID: 23735.1296070767@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
Cristiano Duarte <cunha17(at)gmail(dot)com> writes:
> I was thinking about an old 2007 topic, where schema 
> qualification was proposed on the EXPLAIN output 
> (http://archives.postgresql.org/pgsql-
> hackers/2007-06/msg00473.php). 

> Besides my need for this "feature" for my own PgFoundry 
> project (that need to parse the explain output), at that time, 
> it seemed that a XML output maybe fit this requirement.

> For some time, postgresql has XML output. So, is it possible 
> to place, at least on the XML output, the schema name of the 
> objects involved?

See EXPLAIN (VERBOSE, FORMAT XML) ...

			regards, tom lane

In response to

pgsql-hackers by date

Next:From: Kevin GrittnerDate: 2011-01-26 19:42:23
Subject: Re: SSI patch version 14
Previous:From: Tom LaneDate: 2011-01-26 19:35:26
Subject: Re: Extensions support for pg_dump, patch v27

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