Re: Schemas: status report, call for developers - Mailing list pgsql-hackers

From Nigel J. Andrews
Subject Re: Schemas: status report, call for developers
Date
Msg-id Pine.LNX.4.21.0205020238370.9945-100000@ponder.fairway2k.co.uk
Whole thread Raw
In response to Re: Schemas: status report, call for developers  (Ian Barwick <barwick@gmx.net>)
Responses Re: Schemas: status report, call for developers  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Thu, 2 May 2002, Ian Barwick wrote:

> Tom Lane wrote:
> [snipped]
> > My gut feeling is that "\d mytab" should tell you about the same
> > table that "select * from mytab" would find.  Anything else is
> > probably noise to you --
> 
> General consistency with SELECT behaviour sounds right to me.


I take it temporary tables are going to be included in such a list, since that
would seem sensible from the SELECT behaviour point of view, and may be even
also from the user's point of view.

So, how does one determine the current schema for temporary tables, i.e. what
name would be in search_path if it wasn't implicitly included? (Just throwing
ideas around in my head)


-- 
Nigel J. Andrews
Director

---
Logictree Systems Limited
Computer Consultants



pgsql-hackers by date:

Previous
From: mlw
Date:
Subject: Re: PostgreSQL mission statement?
Next
From: Tom Lane
Date:
Subject: Re: insert with multiple targetLists