The OSGeo FDO provider for PostgreSQL/PostGIS has 32-bit and 64-bit versions on Windows and Linux. For AutoCAD Map 3D, it is certified for PostGIS 1.5 with PostgreSQL 9.0.
To bring in features from PostgreSQL/PostGIS
- In
Display Manager
, click Data
Connect To Data. - In the Data Connect window, select Add PostgreSQL Connection in the Data Connections By Provider list.
- Under Connection Name, type a name for this connection.
- Enter the Service Name and click Login.
The service name is set when you install the PostgreSQL server.
- In the User Credentials dialog box, specify the login credentials to use to log into this data store.
- In Data Connect, under Data Store, enter the data store name. If you do not know this name, check with your System Administrator.
To select from a list of data stores, click the down arrow. AutoCAD Map 3D connects to the specified server and instance and lists the available data stores.
- Click Connect.
- In the feature class list, select the feature classes to include in the map.
If this feature source contains only a single feature class, that feature class is selected automatically. If it contains multiple feature classes, you can do either of the following:
- Right-click the schema entry and select Select All or Select None.
- Expand the schema entry and select the feature classes to add.
If a feature class contains multiple geometry types,and you select the feature class itself, all geometries are added. To add a subset of geometries, hold your cursor over the feature class name to see the Show Geometry button. Click Show Geometry to see each geometry as a separate choice. Select the ones you want. Each selected geometry is added to map as a separate Display Manager layer.
- Verify that the coordinate systems are correct. You can change an incorrect coordinate system if necessary.
- Click Add To Map.