Re: psql :: support for \ev viewname and \sv viewname - Mailing list pgsql-hackers

From Tom Lane
Subject Re: psql :: support for \ev viewname and \sv viewname
Date
Msg-id 14798.1435953043@sss.pgh.pa.us
Whole thread Raw
In response to Re: psql :: support for \ev viewname and \sv viewname  (Petr Korobeinikov <pkorobeinikov@gmail.com>)
Responses Re: psql :: support for \ev viewname and \sv viewname  (Dean Rasheed <dean.a.rasheed@gmail.com>)
List pgsql-hackers
Petr Korobeinikov <pkorobeinikov@gmail.com> writes:
> Fixed. Now both \ev and \sv  numbering lines starting with "1". New version
> attached.

Applied with a fair amount of mostly-cosmetic adjustment.

> As I've already noticed that pg_get_viewdef() does not support full syntax
> of creating or replacing views.

Oh?  If that were true, pg_dump wouldn't work on such views.  It is kind
of a PITA for this purpose that it doesn't include the CREATE text for
you, but we're surely not changing that behavior now.
        regards, tom lane



pgsql-hackers by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: Fix broken Install.bat when target directory contains a space
Next
From: Martijn van Oosterhout
Date:
Subject: Re: WAL logging problem in 9.4.3?