Re: View String or Representation

Gregory Seidman wrote:
> SERFIOTIs gewrgios sez:
> } 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!
>
> If you use psql, you can type \d <viewname> to get the definition of the
> view. If you start psql with the -E and type that you will see the SQL that
> psql is invoking to find the information, including the reference to the
> pg_views system table.

pg_views isn't a system table at all! It is a view itself :-)

This system view is calling a function that reconstructs the
view definition from the information stored in pg_rewrite,
which is an ASCII representation of the internal parsetree
format of a query rewrite rule.

Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck(at)Yahoo(dot)com #