Re: SHOW TABLES - Mailing list pgsql-hackers

From Joshua D. Drake
Subject Re: SHOW TABLES
Date
Msg-id 1279316291.3623.11.camel@jd-desktop.iso-8859-1.charter.com
Whole thread Raw
In response to Re: SHOW TABLES  (Brendan Jurd <direvus@gmail.com>)
List pgsql-hackers
On Sat, 2010-07-17 at 07:36 +1000, Brendan Jurd wrote:
> On 17 July 2010 07:26, Joshua D. Drake <jd@commandprompt.com> wrote:
> > Yes. We should provide a single, well described grammar for interacting
> > with objects in the database regardless of client. I should be able to
> > open ANY SQL terminal, and type SHOW ME THE MONEY and have Benjamins
> > fall out.
> 
> postgres=# SHOW ME THE MONEY;
> WARNING: THE MONEY is deprecated in this version of Postgres and may
> be discarded in a future version
> HINT: Use SHOW ME THE NUMERIC with the desired precision instead.

Funny, but no longer true:

http://www.postgresql.org/docs/8.4/static/datatype-money.html

(although I wish we would get rid of the type)

JD

> 

-- 
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579
Consulting, Training, Support, Custom Development, Engineering



pgsql-hackers by date:

Previous
From: Alex Hunsaker
Date:
Subject: Re: Functional dependencies and GROUP BY
Next
From: Simon Riggs
Date:
Subject: Re: ALTER TABLE SET STATISTICS requires AccessExclusiveLock