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