Application: gvSIG desktop » gvSIG data provider for PostgreSQL

import java.sql.Connection;

import java.sql.DatabaseMetaData;

    private int[] databaseVersion = null;

    protected int[] getDatabaseVersion() {

        if( databaseVersion == null ) {

            Connection conn;

            try {

                conn = this.getHelper().getConnection();

                DatabaseMetaData metadata = conn.getMetaData();

                databaseVersion =  new int[] {

                    metadata.getDatabaseMajorVersion(),

                    metadata.getDatabaseMinorVersion()

                };

            } catch (Exception ex) {

                databaseVersion = new int[] { 0,0 };

            }

        }

        return databaseVersion;

    }

                int[] version = getDatabaseVersion();

                if( version[0]>=9 && version[1]>=5 ) {

                    builder.append("IF NOT EXISTS ");

                }