CREATE VIEW form stored in database? - Mailing list pgsql-sql

From Mario Splivalo
Subject CREATE VIEW form stored in database?
Date
Msg-id 1138701111.8587.3.camel@localhost.localdomain
Whole thread Raw
Responses Re: CREATE VIEW form stored in database?  (Richard Huxton <dev@archonet.com>)
List pgsql-sql
When I create a view, I like to define it like this (just representing
the form here):

CREATE VIEW vw_my_view
AS
SELECTt1.col1,t2.col2
FROMt1JOIN t2    ON t1.col1 = t2.col3
WHEREt2.col4 = 'bla'


But, when I extracit it from postgres, it's somehow stored like this:

CREATE VIEW vw_my_view
AS
SELECT    t1.col1, t2.col2
FROM    t1
JOIN    t2 ON t1.col1 = t2.col3
WHERE    t2.col4 = 'bla'

The later is much more hard to read, and when I need to change the view,
i get rash and stuff :)

Is there a way to tell postgres NOT to format the 'source code' of my
views?
Mike
-- 
Mario Splivalo
Mob-Art
mario.splivalo@mobart.hr

"I can do it quick, I can do it cheap, I can do it well. Pick any two."




pgsql-sql by date:

Previous
From: AKHILESH GUPTA
Date:
Subject: regarding debugging?
Next
From: Richard Huxton
Date:
Subject: Re: CREATE VIEW form stored in database?