Re: [GENERAL] How to Examine a view

is this what you mean? testdb=# \d foo_view View "public.foo_view" Column | Type | Modifiers +---+--- x | character varying(20) | stuff | text | y | character varying(20) | View definition: SELECT a.x

[GENERAL] How to Examine a view

I have setup a view consisting of two tables and some compound fields. Now I would like from the client perspective see what those compound fields actually are originally. Let's (for simplicity I have inlcuded only one table) say we have: CREATE OR REPLACE VIEW clientview AS SELECT c.clientid, (c