Re: psql :: support for \ev viewname and \sv viewname

Поиск
Список
Период
Сортировка
От Petr Korobeinikov
Тема Re: psql :: support for \ev viewname and \sv viewname
Дата
Msg-id CAJL5ff-B2LQPoVJtA6T_RAeZekX5BFjMA2+BASEO+_bN33OxeA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: psql :: support for \ev viewname and \sv viewname  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: psql :: support for \ev viewname and \sv viewname  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Дерево обсуждения


пт, 3 июля 2015 г. в 19:30, Tom Lane <tgl@sss.pgh.pa.us>:
So AFAICS, \ev and \sv should just number lines straightforwardly, with
"1" being the first line of the CREATE command text.  Am I missing
something?

Fixed. Now both \ev and \sv  numbering lines starting with "1". New version attached.

As I've already noticed that pg_get_viewdef() does not support full syntax of creating or replacing views. In my opinion, psql source code isn't the place where some formatting hacks should be. So, can you give me an idea how to produce already formatted output supporting "WITH" statement without breaking backward compatibility of pg_get_viewdef() internals?
Вложения

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: Synch failover WAS: Support for N synchronous standby servers - take 2
Следующее
От: Amit Kapila
Дата:
Сообщение: Re: Let PostgreSQL's On Schedule checkpoint write buffer smooth spread cycle by tuning IsCheckpointOnSchedule?