Cannot find my manually entered notes in the Database shema

Discuss how to create custom stats, reports and HUD profiles and share your creations.

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

Cannot find my manually entered notes in the Database shema

Postby Borsaci007 » Wed Jul 26, 2017 6:00 pm

Hello all,

The PostgreSQL database table "notes" has the column "note", which should be "The text of the note".

But if I use this PostgreSQL Code :

SELECT note FROM notes;

all entries of the column "note" are :

"<?xml version="1.0" encoding="UTF-8"?>"

In the Pokertracker Software, when I use the replayer, I can see easely every manually entered Note, but in the PostgreSQL Shema, I cannot find and see these Notes.
Can you please explain me, where my manually entered notes are stored in your Database and where I can see the manually entered text in the Database Shema?

Thanks in Advance
Borsaci007
 
Posts: 17
Joined: Wed Jan 27, 2010 5:30 pm

Re: Cannot find my manually entered notes in the Database sh

Postby Flag_Hippo » Thu Jul 27, 2017 2:01 pm

You will need to expand the 'note text' window to see all the information contained inside however that will likely be truncated using that query so you may still not see the text of the notes. If you want to see all the information then right-click the 'notes' column and select 'View Data' instead where you can double click on the 'note text' field to view/edit it.
Flag_Hippo
Moderator
 
Posts: 14441
Joined: Tue Jan 31, 2012 7:50 am


Return to Custom Stats, Reports and HUD Profiles

Who is online

Users browsing this forum: No registered users and 23 guests

cron