The Copy tool in ArcGIS Pro copies whole values in a 'Double' field as decimals in a PostgreSQL enterprise geodatabase.

Workaround

Create an empty feature class in the PostgreSQL enterprise geodatabase with the same fields or data types. Run the Append tool to append the data successfully without decimal places appearing.

1. Right-click the PostgreSQL enterprise geodatabase Spatial Database Engine (SDE) connection in the Catalog pane > New > Feature Class.
2. Add a new field with the Double data type in the Create Feature Class pane.
3. Click Finish to finish creating the new feature class.
4. Once created, open the Geoprocessing pane and search for the Append tool. Set the parameters as below:
   1. Input Datasets: The file geodatabase feature class.
   2. Target Dataset: The enterprise geodatabase empty feature class.
   3. Field Matching Type: Use the field map to reconcile field differences.

Schritte zur Reproduzierung