Using PT DB to learn SQL - getting started
Posted: Sat Feb 07, 2009 10:19 pmHi, I'm just beginning to teach myself SQL. I thought it would be fun to use my old PostgreSQL poker tracker database to test out new skillz as I develop them. It's a small db of about 20,000 Omaha Hi-Lo hands. I'm looking for some help/guidance/advice in getting started:
1) Is there a list of the table and field names used for PTO Omaha? I'd like to learn and explore the structure of the database.
2) Is there a way to work on a copy of my current database so that if I screw something up it won't interefere with using PTO with that data in the future? i.e. I'd rather not work on the db that PTO currently relies upon. It's not important for the one I mess around with to be updated anymore, but I'd rather not start over with a new SQL db when I play and use PTO from now on.
3) I'm using PostgreSQL 8.0 on a Windows XP machine; I assume I'll be using the psql interactive terminal to connect to the db. Any other programs/methods I should consider using for working with the data.
4) Any general comments or advice as I undertake this endeavor are also welcome. . .
Thanks!
1) Is there a list of the table and field names used for PTO Omaha? I'd like to learn and explore the structure of the database.
2) Is there a way to work on a copy of my current database so that if I screw something up it won't interefere with using PTO with that data in the future? i.e. I'd rather not work on the db that PTO currently relies upon. It's not important for the one I mess around with to be updated anymore, but I'd rather not start over with a new SQL db when I play and use PTO from now on.
3) I'm using PostgreSQL 8.0 on a Windows XP machine; I assume I'll be using the psql interactive terminal to connect to the db. Any other programs/methods I should consider using for working with the data.
4) Any general comments or advice as I undertake this endeavor are also welcome. . .
Thanks!
