From: | "Dave Page" <dpage(at)postgresql(dot)org> |
---|---|
To: | rod(at)iol(dot)ie |
Cc: | Pgadmin-Support <pgadmin-support(at)postgresql(dot)org> |
Subject: | Re: Column names in view |
Date: | 2007-11-24 14:25:20 |
Message-ID: | 200711241425210000@074528367 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
> ------- Original Message -------
> From: "Raymond O'Donnell" <rod(at)iol(dot)ie>
> To: Pgadmin-Support <pgadmin-support(at)postgresql(dot)org>
> Sent: 24/11/07, 14:02:15
> Subject: [pgadmin-support] Column names in view
>
> Hi all,
>
> A funny one I see from time to time....I have one particular view which,
> when I click "View data", doesn't show up the column names in pgAdmin.
> It (pgAdmin) shows the names in two other views in the same database
> without any problem.
>
> SELECTing from the view in psql shows the column names, as does
> SELECTing in the query tool.
>
> There's nothing special about this view that I can see - it joins 5
> tables together, and one column is calculated in the view (and given an
> alias also).
How odd.
> I can send a dump of the database if it's any use - it's a development
> one, and so quite small (160kb zipped).
>
Please do.
/D
From | Date | Subject | |
---|---|---|---|
Next Message | Raymond O'Donnell | 2007-11-24 14:34:49 | Re: Column names in view |
Previous Message | Raymond O'Donnell | 2007-11-24 14:25:03 | Re: Re : Column names in view |