> ------- Original Message -------
> From: "Raymond O'Donnell" <rod@iol.ie>
> To: Pgadmin-Support <pgadmin-support@postgresql.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