Toad World® Forums

How do I get toad data point to display full decimal precision that is in the database?


#1

I am connecting using Toad Data Point 3.8.0.575 and connection to an AWS aurora postgresql database. I have two columns or LAT / LON that are double percision data types in the database. Using pgAdmin I can see both fileds have 6 decimal places. When view the table, run a query, or do an export I only get 4 decimal places for longitude and 5 for latitude or a total of 7 digits. Toad sees the data type as float8.

How can I get toad to show and export the full decimal.

Thanks,

Daniel Clausen


#2

We have better support for PostgresSQL in our Beta. Can you download and try and let us know if this is resolved? Use the Postgres SQL type and not generic ODBC

https://community.toadworld.com/products/toad-data-point/toad_data_point_beta_program/


#3

Did you get a chance to try the Beta?