export hands

[makodim]

how in database pt4 me can export ONLY hands ONE players (not all sessions), in pt3 database me can use this

Click Start --> Programs --> PostgreSQL --> psql to 'postgres'.

select history from holdem_hand_histories, holdem_hand_player_detail, player where holdem_hand_histories.id_hand = holdem_hand_player_detail.id_hand and holdem_hand_player_detail.id_player = player.id_player and player.player_name = 'Your Username Here'

[makodim]

in pt4 database see - ERROR: relation "holdem_hand_histories" does not exist

[kraada]

The equivalent query in PT4 would be:

select history from cash_hand_histories, cash_hand_player_statistics, player where cash_hand_histories.id_hand = cash_hand_player_statistics.id_hand and cash_hand_player_detail.id_player = player.id_player and player.player_name = 'Your Username Here'

[makodim]

now ERROR: syntax error at or near "select"

[kraada]

Missed one small change. This works:

select history from cash_hand_histories, cash_hand_player_statistics, player where cash_hand_histories.id_hand = cash_hand_player_statistics.id_hand and cash_hand_player_statistics.id_player = player.id_player and player.player_name = 'Your Username Here';