From: | Vivekanand Joshi <vjoshi(at)zetainteractive(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | How to upgrade psql client |
Date: | 2015-02-09 14:25:20 |
Message-ID: | 6658be918d92355be589a80f7b941ff2@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi Team,
I want to upgrade my psql client which is version 8.1.23 right now. I am
not been able to see the DDL for the tables using \d option. I have
installed PostgreSQL through source.
How to upgrade the client?
============================
postgres=# select version ();
version
--------------------------------------------------------------------------
-------------------------------------
PostgreSQL 9.3.5 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.1.2
20080704 (Red Hat 4.1.2-44), 64-bit
(1 row)
===============================
psql -U postgres -W
Welcome to psql 8.1.23 (server 9.3.5), the PostgreSQL interactive
terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit
WARNING: You are connected to a server with major version 9.3,
but your psql client is major version 8.1. Some backslash commands,
such as \d, might not work properly.
=====================================
Thanks,
Vivek
From | Date | Subject | |
---|---|---|---|
Next Message | John Scalia | 2015-02-09 14:46:47 | Re: How to upgrade psql client |
Previous Message | Oliver | 2015-02-09 14:11:52 | Re: Change postgresql encoding |