How to upgrade psql client

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

Responses

Browse pgsql-admin by date

  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