Can I import a shapefile to Postgres database from ArcGIS Pro?

[IreneAlberty]

I want to import a shapefile to my PostGIS Database (Postgres) using ArcGIS Pro, as QGIS does with Database Manager.

[George_Thompson]

It is a geodatabase or just a DB?

What is the license level of ArcGIS Pro being used (Basic, Standard, Advanced)?

You should be able to add a new feature class to a Postgres DB from ArcGIS Pro.

[BruceHarold]

First add a spatial type:

https://pro.arcgis.com/en/pro-app/help/data/databases/overview-database-spatial-types.htm#ESRI_SECTI... 

Add the ST_Geometry type to a PostgreSQL database—Help | Documentation 

[IreneAlberty]

My Postgres DB has already the PostGIS extension, is it enough?

thanks!

[BruceHarold]

Yes

[IreneAlberty]

It's Postgres DB with a PostGIS Extension. 

My license level of ArcGIS Pro is Basic. 

I've tried to use the tool Feature Class to Geodatabase, with my Postgres DB connection but I got the error "000210 Cannot create output". 

Which tool or process do you recommend? 

Thanks!

[BruceHarold]

Please try Feature Class to Feature Class

[IreneAlberty]

I've tried Feature Class to Feature Class and got this error:

ERROR 000210: Cannot create output C:\Users\GIS_User2\Documents\ArcGIS\Projects\MyProject\psql-prcave-hub-dev.postgres.database.azure.com.sde\vieques

Failed to execute (FeatureClassToFeatureClass).

[BruceHarold]

I suspect the PostGIS spatial types are not enabled in your database, please see the PostGIS documentation referred to in our help:

PostGIS is a third-party, open source installation. To use the PostGIS geometry or geography type, install PostGIS on the PostgreSQL database cluster. Once installed, either use the PostGIS template database to create a database containing the PostGIS types, or configure an existing database to use the PostGIS types. See PostGIS documentation for information on the installation and configuration of PostGIS.

[IreneAlberty]

Thanks for your answer.

I've just checked the PostGIS installation and the geometry columns in my database: I have the installation and the spatial types (geometry).

Do you suspect anything else?

Thanks!