SQL query

[Lespaulka001]

Hello!

I would like to get from HM database, the following datas:

all players name, vpip, pfr, hand number.

How should I write the query in pgadmin?

Thanks for your help!

[netsrak]

You know how to use the pgadmin query tool?

I can't give the exact SQL statement for what you are looking for but this should help you:

Close down HM and open the holdemmanager.config with notepad and change
<setting name="LogDatabaseCommands">False
To
<setting name="LogDatabaseCommands">True

Now run the report and when it finishes look in the logs folder for a file named dbtrace.log and open it with Wordpad and go to the bottom of the file and you will see the query.