Subject: CREATE VIEW form stored in database?
From: Mario Splivalo <mario.splivalo@mobart.hr>
Reply-To: mario.splivalo@mobart.hr
To: pgsql-sql@postgresql.org
Content-Type: text/plain
Organization: Mob-Art
Date: Tue, 31 Jan 2006 10:51:51 +0100
Message-Id: <1138701111.8587.3.camel@localhost.localdomain>
Mime-Version: 1.0
Content-Transfer-Encoding: 7bit

When I create a view, I like to define it like this (just representing
the form here):

CREATE VIEW vw_my_view
AS
SELECT
	t1.col1,
	t2.col2
FROM
	t1
	JOIN t2
		ON t1.col1 = t2.col3
WHERE
	t2.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."