> > Sorry Postgresql has really made my VIEWS ugly. > It wasnt' so when i fed them. > > I wish pgsql stores the create view defination some day , > just like it does for indexes (pg_get_indexdef) > Did you ever try
SELECT * FROM pg_views ; It definitely has all view definitions. Regards, Christoph ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html