I have an ArcGIS For Desktop license, and we have a PostgreSQL 9.2/PostGIS 2 database server running in our network. We currently use Query Layers to add the PostgreSQL data to ArcMap sessions.
We would like to make full use of ESRI's geodatabase functionality, without committing to the (we have heard) somewhat unreliable FGDB format.
I see that using the "Create Enterprise Geodatabase" geoprocessing tool one can create a database and have it set-up as a geodatabase, but this requires the input of an authorization key, which it seems is only available with a Server license (true?).
My question: Can we not just turn this diagram, or better, this schema into a series of CREATE statements for the PostgreSQL database in order to generate the equivalent database schema ourselves, and then utilize it from ArcCatalog as we would a file geodatabase, without any "authorization key"?
My thanks for the clarification.