Re: View String or Representation
Gregory Seidman <gss+pg@cs.brown.edu>
From: Gregory Seidman <gss+pg@cs.brown.edu>
To: pgsql-general@postgresql.org
Date: 2002-06-11T16:11:49Z
Lists: pgsql-general
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. } Thank you, } George. --Greg