ImportFromPostGIS

Import multiple layers from PostgreSQL/PostGIS database

Converts multiple layers from PostgreSQL extended with the PostGIS spatial data support to shapefiles or File GDB layers.

The interface of ET GeoWizards allows to create a list of frequently used services and manage them.
The outputs will preserve the spatial reference of the input layers.
The function is not available in the Toolboxes for ArcGIS Desktop and ArcGIS Pro.

Parameters

Expression	Explanation
Function Name	ImportPostGISLayers
<Input Host>	A String - see above.
<Input Database>	A String - the name of the database.
<Input Layers Names>	A String representing a list of the names of the layers to be converted. The format of the list is "LayerName1;LayerName2;LayerName3". Note that is an empty string is passed, all layers available will be imported.
<output workspace>	A String - the full name to the folder or FileGDB where the outputs will be stored.
<Port>	A String representing the Port for communication with the PostgreSQL server
<User Name>	A String representing the User Name.
<Pasword>	A String representing the Password.

ETGWPath used in the table below is the full path to ETGWRun.exe (E.G. "C:\Program Files\ETSpatial Techniques\ETGeo Wizards\ETGWRun.exe")

Language	Syntax
Python	subprocess.call([ETGWPath, "ImportPostGISLayers", "Input Host", "Input Database", "Input Layers Names", "output workspace", "Port","User Name","Pasword"])
.NET using ETGWRun.exe	StartInfo.FileName = ETGWPath StartInfo.Arguments = "ImportPostGISLayers" "Input Host" "Input Database" "Input Layers Names" "output workspace" "Port" "User Name" "Pasword"
.NET using ETGWOutX.dll	ImportPostGISLayers(Input Host, Input Database, Input Layers Names, output workspace, Port, User Name, Pasword)

Notes:

<> - required parameter
{} - optional parameter
See examples for Python , .NET or ArcPy
The argument separator for StartInfo.Arguments is space. If a string might contain a space, you need to double quote it.