Re: new psql \d command - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: new psql \d command
Date
Msg-id 20030808180104.GA17514@dcc.uchile.cl
Whole thread Raw
In response to Re: new psql \d command  ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>)
List pgsql-hackers
On Fri, Aug 08, 2003 at 09:17:05AM +0800, Christopher Kings-Lynne wrote:

> australia=# \d affiliates_transactions
>         View "public.affiliates_transactions"
[...]
> View definition:
>  SELECT palm_buyers.affiliate_id, timestamptz(abstime(palm_buyers.datetime))
> AS
> date, 'Palm' AS "type", 1 AS type_id, palm_buyers.affiliate_amount AS amount
>    FROM palm_buyers
>   WHERE palm_buyers.affiliate_id IS NOT NULL AND
> palm_buyers.affiliate_amount IS
>  NOT NULL
> UNION ALL
>  SELECT palm_buyers.affiliate_id,
> timestamptz(abstime(palm_buyers.refund_datetim
> e)) AS date, 'Palm Refund' AS "type", 2 AS type_id, -
> palm_buyers.affiliate_amou
> nt AS amount

Is this the real output or you were bitten by cut&paste wrapping?  It
doesn't look good to me as is...

[several other cases in the rest of the definition]

-- 
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"The ability to monopolize a planet is insignificant
next to the power of the source"


pgsql-hackers by date:

Previous
From: Sean Chittenden
Date:
Subject: Re: Correlation in cost_index()
Next
From: Josh Berkus
Date:
Subject: Re: PROCEDURES was: TODO items