Database name question

PostgreSQL is the database server used to store information. Do you have a question or are you having problem with PostgreSQL? If so, post them here.

Moderator: Moderators

Database name question

Postby DrewOnTilt » Fri Jan 01, 2010 4:19 pm

Hi all!

I am doing some computer housekeeping and am deleting PSQL databases that I no longer use. I have two databases that are named "nl_main," the only difference being is that one's name is capitalized and the other is lower case. One of them is a PT3 database, and the other is an old PT2 database. I don't know which is which, though, since they both have the same name. I want to keep the PT3 database and delete the PT2 database. How can I determine which is which?
DrewOnTilt
 
Posts: 134
Joined: Fri Jan 25, 2008 6:34 pm

Re: Database name question

Postby DrewOnTilt » Fri Jan 01, 2010 4:35 pm

never mind i figured it out
DrewOnTilt
 
Posts: 134
Joined: Fri Jan 25, 2008 6:34 pm

Re: Database name question

Postby WhiteRider » Fri Jan 01, 2010 4:38 pm

If you open them both in PGAdmin III and expand the database tables (select the database, then Schemas > public > Tables) you can compare tables in your two databases with those of another PT3 database (if you have one).
I'll attach an image here of a PT3 database - this is from before Beta 30, if you're using that you will have more tables as well (for the omaha data), but you should still see these tables too.
Attachments
Image1.png
WhiteRider
Moderator
 
Posts: 54018
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Database name question

Postby WhiteRider » Fri Jan 01, 2010 4:38 pm

OK, cool. :)
WhiteRider
Moderator
 
Posts: 54018
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK


Return to PostgreSQL [Read Only]

Who is online

Users browsing this forum: No registered users and 26 guests

cron