Re: Column names in view

["Dave Page" <dpage(at)postgresql(dot)org>]

> ------- 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