<< Click to Display Table of Contents >> Navigation:  Connectors > PostgreSQL > Routine Calls

 

The DTS PostgreSQL Connector supports remote calls for any PostgreSQL stored functions.

Stored Procedures are not currently supported. Please see Limitations for details and workarounds.

 

DTS Naming

 

 

Arguments and Results

 

▪Any of the supported data types are also supported as procedure/function argument and result types, including the user-defined types.

▪Functions returning tables will be have their results wrapped and operated as DTS streams.

Native geometry types can only be used as function inputs when they are direct arguments. Please see Limitations for details.

 

 

Metadata

 

The connector is also capable of extracting metadata regarding the arguments and results of a function:

 

▪DATA_TYPE

▪UDT_NAME

▪DATA_PRECISION

▪DATA_SCALE

▪DATA_LENGTH

▪POSITION

▪DEFAULT_VALUE

▪SEQUENCE

▪IN_OUT

 

Standard functionality only makes use of DATA_TYPE, UDT_NAME and POSITION, but the other items are available for extension in DTS descriptor objects.