From: | "Kathi Arthur" <karthur(at)coloradomtn(dot)edu> |
---|---|
To: | "Len Morgan" <len-morgan(at)crcom(dot)net> |
Cc: | "PostgreSQL General Listserv" <pgsql-general(at)postgresql(dot)org>, "Kathi Arthur" <karthur(at)coloradomtn(dot)edu> |
Subject: | Re: database does not exist in system catalog |
Date: | 2001-08-06 20:47:29 |
Message-ID: | 011101c11eb9$01fdfc50$3204a8c0@ITPC03 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Len, Tom, et al --
When I'm connected to template1, \l only shows template1. In the "base" subdirectory, I do have the template1 subdir as well as the bullprod subdir with all the schemas I want. So what am I missing to make THAT db part of the system catalog (data dictionary)? I'm sure it's very obvious... Just not to me!
-- Kathi
----- Original Message -----
From: Len Morgan
To: Kathi Arthur
Sent: Monday, August 06, 2001 2:28 PM
Subject: Re: [GENERAL] database does not exist in system catalog
Kathi;
Thank you, I don't think I WANT to know where the name came from. I believe there is a psql command ( \l ) that will list all database names the Postgres is aware of. I believe that you can also look in the postgres database directory under the "base" subdirectory and see another directory for each database. Becareful changing those names though. You might at least find that you inadvertantly created it with a different name than you think. Maybe the SYSTEM needed an explaination for the name! :-)
Good luck,
len
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2001-08-06 21:27:02 | Use int8 for int4/int2 aggregate accumulators? |
Previous Message | Allan Engelhardt | 2001-08-06 20:38:23 | Re: tables in tables |