Re: Column names in view

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

Responses

Browse pgadmin-support by date

  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