Reply-To: <vjoshi@zetainteractive.com>
From: Vivekanand Joshi <vjoshi@zetainteractive.com>
MIME-Version: 1.0
thread-index: AdBEc99PHpOKujYSQCaORZzGw4/OMA==
Date: Mon, 9 Feb 2015 19:55:20 +0530
Message-ID: <6658be918d92355be589a80f7b941ff2@mail.gmail.com>
Subject: How to upgrade psql client
To: pgsql-admin@postgresql.org
Content-Type: text/plain; charset=UTF-8
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

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


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