Postgres sql request
Results 1 to 2 of 2
  1. #1
    Member
    Join Date
    Nov 2011
    Posts
    59

    Default Postgres sql request

    Hi

    I am looking for an opportunity to see requests sent to the database while defining/changing filters in "More filters" tab. (For instance number of players)
    I tried logging DBControlPanel option (and other options), but there is no such data in the log file.
    I am sure it is possible to get that info while using PT3, but since HM2 stores/organizes info in the database differently, the PT3 requests is not applicable to HM2 database.
    Could you tell me where I could find that info.
    Thank you in advance


    It is how it looks in PT3 (its only a part of the request)
    SELECT (cash_hand_summary.id_hand) as "id_hand", (cash_hand_summary.id_site) as "id_site", (cash_hand_summary.hand_no) as "hand_no", (cash_hand_summary.id_gametype) as "id_gametype_summary", (cash_hand_summary.flg_note) as "flg_note", (cash_hand_summary.flg_tag) as "flg_tag", (timezone('UTC', cash_hand_player_statistics.date_played + INTERVAL '0 HOURS')) as "date_played", (cash_hand_player_statistics.id_limit) as "id_limit", (cash_hand_player_statistics.amt_won) as "amt_won", (cash_limit.limit_currency) as "limit_currency", ((case when( cash_hand_player_statistics.val_curr_conv != 0) then cash_hand_player_statistics.val_curr_conv*cash_han d_player_statistics.amt_won else 0.0 end)) as "amt_won_curr_conv", ( (CASE WHEN ( cash_limit.amt_bb) <> 0 THEN ((cash_hand_player_statistics.amt_won * 1.0 )/( cash_limit.amt_bb)) ELSE 0 END) ) as "amt_bb_won", (CASE WHEN ( (cash_limit.amt_bb) ) <> 0 THEN (( (cash_hand_player_statistics.amt_expected_won) * 1.0 )/( (cash_limit.amt_bb) )) ELSE 0 END) as "amt_expected_bb_w
    Last edited by Perception; 01-23-2019 at 10:26 AM.

  2. #2
    You're out! udbrky's Avatar
    Join Date
    Jul 2008
    Posts
    20,898

    Default

    What exactly are you trying to do here?
    Regards udbrky (Chris)

Similar Threads

  1. Postgres SQL Fatal Errors
    By WahineLil in forum Manager General
    Replies: 15
    Last Post: 06-06-2010, 07:35 AM
  2. Postgres SQL on an USB-Stick
    By prize-man in forum Manager General
    Replies: 19
    Last Post: 07-03-2009, 03:26 PM
  3. high cpu usage by postgres sql when HM open
    By rokketeer in forum Manager General
    Replies: 1
    Last Post: 04-25-2009, 04:41 PM
  4. PT3 user: Postgres Sql db install?
    By simon_cph in forum Manager General
    Replies: 1
    Last Post: 11-03-2008, 03:53 PM
  5. Postgres SQL Password
    By mr miyagi in forum Manager General
    Replies: 1
    Last Post: 10-25-2008, 12:35 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •