Re: [GENERAL] Alter view with psql command line

2017-02-10 Thread David Fetter 
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  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

Re: [GENERAL] Alter view with psql command line

2017-02-10 Thread Leonardo M . Ramé 

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

Re: [GENERAL] Alter view with psql command line

2017-02-10 Thread Adrian Klaver 

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.kla...@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

[GENERAL] Alter view with psql command line

2017-02-10 Thread Leonardo M . Ramé 
Hi, is there a way to alter a view using *psql*?, something like what 
\ef does for functions.


Regards,
--
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