Try looking in pg_views (I'm on 7.2) for more info.
\dS shows you all the system tables that are normally hidden.
On Tue, 11 Jun 2002, SERFIOTIs gewrgios wrote:
> Hi,
> does anyone know when I create a view where does Postgresql
> store the string with the view definition or any other internal
> representation of the view?
>
> I have looked up for the question in two Postgresql manual without finding
> an answer!
>
> Thank you,
> George.
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>