CREATE VIEW form stored in database?

Поиск
Список
Период
Сортировка
От Mario Splivalo
Тема CREATE VIEW form stored in database?
Дата
Msg-id 1138701111.8587.3.camel@localhost.localdomain
обсуждение исходный текст
Ответы Re: CREATE VIEW form stored in database?  (Richard Huxton <dev@archonet.com>)
Список 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 по дате отправления:

Предыдущее
От: AKHILESH GUPTA
Дата:
Сообщение: regarding debugging?
Следующее
От: Richard Huxton
Дата:
Сообщение: Re: CREATE VIEW form stored in database?