I am trying to port my data from Ingres to Postgres( that has come with Linux distribution)
I found that Ingres prepends all the strings from database with the no. of characters while unloading.
So if a varchar-filed in Ingres has "Syscon" as the value it would have "6Syscon" when unloaded.
But When I reloaded the whole data in Postgres I had "6Syscon" in my database.So I wanted
to write a C programme with embedded Sql to take care of all such bad-data. But I get the ecpg not found.
I checked all the bin directories where it could be but couldn't found.Do I need to buy the stuff and install it.
If yes then how and from whom.
Thanks very much !
Nimesh