Total number of hands in database

[DrewOnTilt]

Is there anywhere that I can see the total number of hands that are in a database? If PT3 doesn't display this anywhere then what SQL command should I use in pgAdmin III?

I need to compare my newly created PT3 database to an older database to ensure that everything imported correctly.

[APerfect10]

[codedh3]SELECT
count(*) as total_hands
FROM
holdem_hand_summary[/codedh3]

[omaha]

Any way for us computertards to find this (very important -hint hint) stat yet?

[Josh]

Not yet, it will be added when the summary tab gets put back in.

[ozora tsubasa]

[quote="omaha"585]Any way for us computertards to find this (very important -hint hint) stat yet?[/quote585]

It's quite easy actually. Open up pgadmin, connect to your database. Then right click on your listed PT3 database and click "Create Script"

Then paste the above script and hit "execute query"

[img585]http://www.karidegiliz.biz/publicpoker/2p248.jpg[/img585]

[_dave_]

[quote="APerfect10"kke][codekke]SELECT
count(*) as total_hands
FROM
holdem_hand_summary[/codekke][/quotekke]

is this not a bit nasty?

aside from that is misses donkaments too

[codekke]SELECT
count(id_hand) as total_hands
FROM
holdem_hand_summary[/codekke]

or

[codekke]SELECT
count(id_hand) as total_hands
FROM
tourney_holdem_hand_summary[/codekke]

?

[APerfect10]

[quotec8x]is this not a bit nasty?[/quotec8x]

From my MySQL days where count(*) is actually faster than count(field)...