On Mon, Feb 9, 2015 at 7:55 PM, Vivekanand Joshi <vjoshi@xxxxxxxxxxxxxxxxxxx> wrote:
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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Hi Vivekanand,
You don't need to upgrade psql client if you have installed PostgreSQL 9.3.5 from sources without specifying --prefix
then your all postgresql 9.3 binaries are under /usr/bin
So you just need to specify the path of that directory in .bash_profile which is under users home directory.
Following example of .bash_profile file.
PATH=/usr/bin:$PATH
export PATH
After creating file just reload the file
source .bash_profile
Hope this will solve your problem.
--
Thanks & Regards,
Harshad Adalkonda
Database Administrator
http://www.shreeyansh.com
