Thread: [GENERAL] Alter view with psql command line
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
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
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
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