backslash D in psql fails - Mailing list pgsql-general

From Lee Roth
Subject backslash D in psql fails
Date
Msg-id 3.0.6.32.19981030112845.007be730@enterprise-eng.com
Whole thread Raw
List pgsql-general
Here is an odd one...

> psql lu                                       # talk to database 'lu'
Welcome to the POSTGRESQL interactive sql monitor:
  Please read the file COPYRIGHT for copyright terms of POSTGRESQL

   type \? for help on slash commands
   type \q to quit
   type \g or terminate with semicolon to execute query
 You are currently connected to the database: lu

lu=> select count(*) from inventory;               # how many records?
count
-----
 5457                                              # works fine!
(1 row)

lu=> \d                                            # what tables have we?
Couldn't find any tables, sequences or indices!    # bizarre!!!
lu=> select version();                             # Hmmm... what version?
ERROR:  function version() does not exist          # how rude!!
lu=> \q                                            # I can't take this anymore
>


-----------

Looking at one of the PG_VERSION files it says '6.3'.

Functionally, the database works fine via DBI/DBD perl modules.

In my environment:

> env | grep '^PG'
PGDATA=/usr/local/pgsql/data
PGLIB=/usr/local/pgsql/lib
>

Any ideas?

Thanks-

Lee Roth
leer@enterprise-engineering.com


pgsql-general by date:

Previous
From: Memphisto
Date:
Subject: Problem with aggregates and group by
Next
From: Ulf Mehlig
Date:
Subject: Re: [GENERAL] Problem with aggregates and group by