Page 1 of 1

Database name question

PostPosted: Fri Jan 01, 2010 4:19 pm
by DrewOnTilt
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?

Re: Database name question

PostPosted: Fri Jan 01, 2010 4:35 pm
by DrewOnTilt
never mind i figured it out

Re: Database name question

PostPosted: Fri Jan 01, 2010 4:38 pm
by WhiteRider
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.

Re: Database name question

PostPosted: Fri Jan 01, 2010 4:38 pm
by WhiteRider
OK, cool. :)