Column names in view
От
Raymond O'Donnell
Тема
Column names in view
Дата
Msg-id
47482EE7.5040602@iol.ie
Список
Дерево обсуждения
Column names in view Raymond O'Donnell <rod@iol.ie>
Re: Column names in view Raymond O'Donnell <rod@iol.ie>
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). I can send a dump of the database if it's any use - it's a development one, and so quite small (160kb zipped). Anyone else see this? I'm using pgAdmin 1.8 on Windows XP SP2, and PG 8.2.5 on the same machine. I seem to recall a bug along these lines in an earlier version of pgAdmin --------------------------------------------------------------- Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland rod@iol.ie ---------------------------------------------------------------
В списке pgadmin-support по дате отправления
От: Dave Page
Дата: