> We actually reverse it on the fly: > > test=> \d xx > View "xx" > Column | Type | Modifiers > ---------+------+----------- > relname | name | > View definition: SELECT pg_class.relname FROM pg_class;
Well, no - that's just dumping out the parsed form. eg. test=# create view v as select 1 in (1,2,3,4); CREATE test=# select * from v; ?column? ---------- t (1 row) test=# \d v View "v" Column | Type | Modifiers ----------+---------+----------- ?column? | boolean | View definition: SELECT ((((1 = 1) OR (1 = 2)) OR (1 = 3)) OR (1 = 4)); It's really annoying when people save their view definition in phpPgAdmin and when they load it up again it's lost all formatting. Functions and rules, for instance keep the original formatting somewhere. Chris ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org