Hello!
Is there a way to indicate for JDBC table exports using the postgresql Driver that it should be exporting a column as a uuid when the dataset itself in Foundry has a String type for the column?
Thanks!
Pat
Hello!
Is there a way to indicate for JDBC table exports using the postgresql Driver that it should be exporting a column as a uuid when the dataset itself in Foundry has a String type for the column?
Thanks!
Pat
In case anyone else has this issue, setting stringtype=unspecified in the JDBC settings seems to allow the Driver to defer to the server. Your mileage may vary!
stringtype (String) Default null
Specify the type to use when binding PreparedStatement parameters set via setString() . If stringtype is set to VARCHAR (the default), such parameters will be sent to the server as varchar parameters. If stringtype is set to unspecified , parameters will be sent to the server as untyped values, and the server will attempt to infer an appropriate type. This is useful if you have an existing application that uses setString() to set parameters that are actually some other type, such as integers, and you are unable to change the application to use an appropriate method such as setInt() .