Skip site navigation (1) Skip section navigation (2)

What Databases are there under this Postgres???

From: reg(at)orion(dot)dwf(dot)com ()
To: pgsql-ports(at)postgresql(dot)org
Subject: What Databases are there under this Postgres???
Date: 2002-06-23 20:06:52
Message-ID: af59os$uii$1@iruka.swcp.com (view raw or flat)
Thread:
Lists: pgsql-ports
Im new to Postgres, but Im in the process of reading the O'Reilly  'Practical PostgreSQL'.

I have a program here (that I am trying to understand) that uses Postgres, but its
getting errors.  It would be 'nice' if I could look at the database and see if 
    (1) the records are not getting written.
    (2) writing is ok, but there is a problem in the code trying to read them.
but I dont even know the NAME of the database that is being written (tht will take some 
more digging in the code,- what Ive tried didnt work).

Is there some way (there must be) to get postgres to tell me what databases exist, owned by what users?
Knowing that data (there's only going to be my test databases and the one written by the
program) would save me a lot of time in debugging...   The only listing I can get sofar just
shows the test databases I have built while reading the book.


-- 
                                        Reg.Clemens
                                        reg(at)dwf(dot)com



pgsql-ports by date

Next:From: Henry B. HotzDate: 2002-06-25 16:36:57
Subject: Re: MAC OSX DB Question
Previous:From: Thomas CastonzoDate: 2002-06-22 03:28:43
Subject: MAC OSX DB Question

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group