Application: gvSIG desktop » gvSIG data provider for PostgreSQL

import java.util.Map;

import org.apache.commons.lang3.StringUtils;

import org.cresques.cts.IProjection;

import org.gvsig.fmap.dal.DataTypes;

import org.gvsig.fmap.dal.exception.DataException;

import org.gvsig.fmap.dal.feature.EditableFeatureAttributeDescriptor;

        return super.getDataTypeFromMetadata(rsMetadata, colIndex);

    }

    protected String getSQLToRetrievePrimaryKeysFromInformationSchema(

            String catalog,

            String schema,

            String table

        ) throws SQLException {

        PostgreSQLBuilder sqlbuilder = (PostgreSQLBuilder) this.createSQLBuilder();

        String column_COLUMN_NAME = "column_name";

        String column_CONSTRAINT_TYPE = "constraint_type";

                + "c.constraint_name = t_cons.constraint_name "

        );

        sqlbuilder.select().where().set(

                )

        );

        if (schema != null) {

            sqlbuilder.select().where().and(

                    )

            );

        }

        if (catalog != null) {

            sqlbuilder.select().where().and(

                    )

            );

        }

        sqlbuilder.select().where().and(

                )

        );

        return sqlbuilder.toString();

        }

        try {

            JDBCSQLBuilderBase sqlbuilder = this.createSQLBuilder();

            sqlbuilder.select().column().name("f_table_catalog");

            sqlbuilder.select().column().name("f_table_schema");

            sqlbuilder.select().column().name("f_table_name");

            sqlbuilder.select().column().name("srid");

            sqlbuilder.select().column().name("type");

            sqlbuilder.select().where().set(

                    )

            );                

            sqlbuilder.select().where().and(

                    )

            );         

            sqlbuilder.select().from().table().name("geometry_columns");