If you import notes into another database then those notes are added to the existing notes in that database. Also if the same note exists in both databases then the note text is appended meaning that it will be doubled up so this isn't ideal if you are going to import notes from one database into another and then back again. If you want to delete existing notes before importing then there isn't a built-in method so you'll need to use PGAdmin and run the following query:
- Code: Select all
TRUNCATE TABLE notes;
To do that double click on PostgreSQL x.y' (where x.y is your PostgreSQL version) and if your prompted for a password the default is "dbpass" (without the quotes), expand 'Databases' and then select your database. The query tool can be opened via its icon in PGAdmin or via 'Tools -> Query Tool' and then you can run the query using 'Query -> Execute'. I'd recommend backing up your poker data before making any changes since PGAdmin is connected directly to your database so take care not to make any other unintended changes to your data while using it.