When you install Thingworx with PostgreSQL, you can't import the "PostgreSQL" extension because of the conflict of a library file.

So, here is a sample "MetaData.xml" file. You can zip this file and simply import it into your Thingworx so that you can have a thing template for "PostgreSQL" database.

 

<Entities>
    <ExtensionPackages>
        <ExtensionPackage name="PostgreSQL_ExtensionPackage"
                      description="PostgreSQL JDBC Extension"
                      vendor="ThingWorx Customer Service"
                      packageVersion="1.0"
                      minimumThingWorxVersion="4.0.0">
        </ExtensionPackage>
    </ExtensionPackages>
    <ThingTemplates>
        <ThingTemplate baseThingTemplate="Database" description="PostgreSQL Server" documentationContent="" effectiveThingPackage="" homeMashup="" lastModifiedDate="2015-11-28T11:40:35.355-05:00" name="PostgreSqlServer" tags="" thingPackage="">
            <ThingShape description="" documentationContent="" lastModifiedDate="2015-11-28T11:40:35.355-05:00" name="" tags="">
                <PropertyDefinitions/>
                <ServiceDefinitions/>
                <EventDefinitions/>
                <ServiceImplementations/>
                <ServiceMappings/>
                <Subscriptions/>
            </ThingShape>
            <ImplementedShapes/>
            <ConfigurationTables>
                <ConfigurationTable description="" isMultiRow="false" name="ConnectionInfo">
                    <DataShape>
                        <FieldDefinitions>
                            <FieldDefinition aspect.defaultValue="5.0" baseType="NUMBER" description="Maximum number of connections in the pool" name="maxConnections" ordinal="0"/>
                            <FieldDefinition aspect.defaultValue="jdbc" baseType="STRING" description="jDBCConnectionURL" name="jDBCConnectionURL" ordinal="0"/>
                            <FieldDefinition aspect.defaultValue="SELECT NOW()" baseType="STRING" description="Connection validation string" name="connectionValidationString" ordinal="0"/>
                            <FieldDefinition aspect.defaultValue="org.postgresql.Driver" baseType="STRING" description="jDBCDriverClass" name="jDBCDriverClass" ordinal="0"/>
                            <FieldDefinition baseType="STRING" description="Database user name" name="userName" ordinal="0"/>
                            <FieldDefinition baseType="PASSWORD" description="Database password" name="password" ordinal="0"/>
                        </FieldDefinitions>
                    </DataShape>
                    <Rows>
                        <Row>
                            <jDBCConnectionURL><![CDATA[jdbc:postgresql://localhost:5432/demo]]></jDBCConnectionURL>
                            <maxConnections>100.0</maxConnections>
                            <connectionValidationString><![CDATA[SELECT NOW()]]></connectionValidationString>
                            <jDBCDriverClass><![CDATA[org.postgresql.Driver]]></jDBCDriverClass>
                            <userName />
                            <password />
                        </Row>
                    </Rows>
                </ConfigurationTable>
                <ConfigurationTable description="" isMultiRow="false" name="ConnectionMonitoring">
                    <DataShape>
                        <FieldDefinitions>
                            <FieldDefinition aspect.defaultValue="1.0" baseType="NUMBER" description="Number of retries" name="numberOfRetries" ordinal="0"/>
                            <FieldDefinition aspect.defaultValue="2000.0" baseType="NUMBER" description="Retry delay in milliseconds" name="retryDelay" ordinal="0"/>
                            <FieldDefinition aspect.defaultValue="false" baseType="BOOLEAN" description="Enable connection monitoring" name="enableMonitor" ordinal="0"/>
                            <FieldDefinition aspect.defaultValue="30000.0" baseType="NUMBER" description="Monitor rate in milliseconds" name="connectionMonitorRate" ordinal="0"/>
                        </FieldDefinitions>
                    </DataShape>
                    <Rows>
                        <Row>
                            <numberOfRetries>1.0</numberOfRetries>
                            <retryDelay>2000.0</retryDelay>
                            <enableMonitor>false</enableMonitor>
                            <connectionMonitorRate>3000.0</connectionMonitorRate>
                        </Row>
                    </Rows>
                </ConfigurationTable>
            </ConfigurationTables>
            <avatar/>
            <DesignTimePermissions>
                <Create/>
                <Read/>
                <Update/>
                <Delete/>
                <Metadata/>
            </DesignTimePermissions>
            <RunTimePermissions/>
            <InstanceDesignTimePermissions>
                <Create/>
                <Read/>
                <Update/>
                <Delete/>
                <Metadata/>
            </InstanceDesignTimePermissions>
            <InstanceRunTimePermissions/>
        </ThingTemplate>
    </ThingTemplates>
</Entities>