in the past I used Toad Mac Edition to access my PostgreSQL server. Since this version is now expired and it is not supported anymore, I’ll have to upgrade to Toad Edge Preview 2.0.1.
My use case is to generate SQL INSERT statements for some selected values in my table. For this I wrote a simple query like “SELECT * FROM users WHERE active=true;”. Then I exported the result set as SQL INSERT statements.
With Toad Edge Preview 2.0.1. I have 15 columns in my export
With Toad Mac Edition I had 16 columns in my export
The annoying thing is, that the missing column is a mandatory column. Therefore my exports are useless.
Some facts about the column which is missing in my export:
its name is “version”
its type is “integer”
it has a default value set which is ‘0’
Does anybody expire the same behavior?
Is there anything I can do here?
Best regards and thank you in advance,