Re: Trouble with views (7.1beta4 Debian) and PgAccess 0.98.7.

From: "Emmanuel Charpentier" <charpent@bacbuc.dyndns.org>


> My present problem is with views : There seems no way to retrieve a view
> definition apart from the psql \dv {viewname} command or select definition
> from pg_views where viewname={viewname}, which I found by trial and error.
>
> - PgAccess 0.98.7 as packaged by Oliver Elphick allows the *creation* of a
> view (which is then readable through psql's \dv), but does not display any
> view. In other words, PgAccess "view" screen seems to be write-only. Ouch
!
>
> Hence a question : shouldn't the system (pg_* and pga_*) tables be
somewhat
> documented at least in the reference manual (and maybe cross-referenced in
the
> programmer's manual) ? They seem not to be at the time ...

try "psql -E" - this will show the queries that \dv uses.

- Richard Huxton