Alter view with psql command line

On 02/10/2017 09:09 AM, Leonardo M. Ram� wrote:

Hi, is there a way to alter a view using *psql*?, something like what
\ef does for functions.

In 9.6:

https://www.postgresql.org/docs/9.6/static/app-psql.html

\ev [ view_name [ line_number ] ]

Regards,

--
Adrian Klaver
adrian.klaver@aklaver.com

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

El 10/02/17 a las 14:17, Adrian Klaver escribi�:

On 02/10/2017 09:09 AM, Leonardo M. Ram� wrote:

Hi, is there a way to alter a view using *psql*?, something like what
\ef does for functions.

In 9.6:

That's why in 9.1 I didn't find that command...

https://www.postgresql.org/docs/9.6/static/app-psql.html

\ev [ view_name [ line_number ] ]

Thanks Adrian.

--
Leonardo M. Ram�
Medical IT - Griensu S.A.
Av. Col�n 636 - Piso 8 Of. A
X5000EPT -- C�rdoba
Tel.: +54(351)4246924 +54(351)4247788 +54(351)4247979 int. 19
Cel.: +54 9 (011) 40871877

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

On Fri, Feb 10, 2017 at 02:26:18PM -0300, Leonardo M. Ram� wrote:

El 10/02/17 a las 14:17, Adrian Klaver escribi�:

On 02/10/2017 09:09 AM, Leonardo M. Ram� wrote:

Hi, is there a way to alter a view using *psql*?, something like what
\ef does for functions.

In 9.6:

That's why in 9.1 I didn't find that command...

You can use the 9.6 client without problems on 9.1, well, apart from
the fact that 9.1 is already past its end of life.

Best,
David.
--
David Fetter <david(at)fetter(dot)org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david(dot)fetter(at)gmail(dot)com

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general