backslash D in psql fails

From: Lee Roth <leer(at)enterprise-eng(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: backslash D in psql fails
Date: 1998-10-30 16:28:45
Message-ID: 3.0.6.32.19981030112845.007be730@enterprise-eng.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)enterprise-engineering(dot)com

Browse pgsql-general by date

  From Date Subject
Next Message Ulf Mehlig 1998-10-30 16:47:31 Re: [GENERAL] Problem with aggregates and group by
Previous Message Memphisto 1998-10-30 15:42:49 Problem with aggregates and group by