Using PT DB to learn SQL - getting started

Forum with tips, support, etc, on using the PostgreSQL database with Poker Tracker. Please post any PostgreSQL questions here.

Using PT DB to learn SQL - getting started

Postby Shaqdeeez » Sat Feb 07, 2009 10:19 pm

Hi, 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!
Shaqdeeez
 
Posts: 3
Joined: Tue Sep 02, 2008 3:17 pm

Return to PostgreSQL Forum

Who is online

Users browsing this forum: No registered users and 17 guests

cron