Delete / purge hands from db via SQL?

Forum for users that want to write their own custom queries against the PT database either via the Structured Query Language (SQL) or using the PT3 custom stats/reports interface.

Moderator: Moderators

Delete / purge hands from db via SQL?

Postby TroyMcLure » Thu Oct 23, 2008 11:28 am

Hi,

i accidentally imported a bunch of mined hands (about 300k - 500k hands) into my played hands db. After searching the forum i know, that it's not possible at the moment to purge them in PT3.
Is there a way to do this via an SQL-Statement directly in the postgres admin interface?

Thx in advance for your help!
TroyMcLure
 
Posts: 10
Joined: Tue Sep 02, 2008 7:45 am

Re: Delete / purge hands from db via SQL?

Postby WhiteRider » Thu Oct 23, 2008 11:39 am

Beta 19 has Selective Purge which will allow you to remove sessions.
Database -> Database Management -> Purge.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Delete / purge hands from db via SQL?

Postby TroyMcLure » Thu Oct 23, 2008 11:48 am

That's great news! Thanks again!
TroyMcLure
 
Posts: 10
Joined: Tue Sep 02, 2008 7:45 am


Return to Custom Stats, Reports, and SQL [Read Only]

Who is online

Users browsing this forum: No registered users and 0 guests