Application: gvSIG desktop » gvSIG data provider for PostgreSQL

/**

 * 

 */

package org.gvsig.fmap.dal.store.postgresql;

import java.sql.Connection;

import java.sql.DatabaseMetaData;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.ResultSetMetaData;

import java.sql.SQLException;

/**

 * @author cordin

 * 

 */

public class DatabaseMetadataChecks {

        // Columns as specified by the DatabaseMetadata.getTables javadoc

        private static final String[] COLUMNS = new String[] {

        // Metadata resultset column names

                        "TABLE_CAT", // String => table catalog (may be null)

                        "TABLE_SCHEM", // String => table schema (may be null)

                        "TABLE_NAME", // String => table name

                        "TABLE_TYPE", // String => table type. Typical types are "TABLE",

                                                // "VIEW", "SYSTEM TABLE", "GLOBAL TEMPORARY",

                                                // "LOCAL TEMPORARY", "ALIAS", "SYNONYM".

                        "REMARKS", // String => explanatory comment on the table

                        "TYPE_CAT", // String => the types catalog (may be null)

                        "TYPE_SCHEM", // String => the types schema (may be null)

                        "TYPE_NAME", // String => type name (may be null)

                        "SELF_REFERENCING_COL_NAME", // String => name of the designated

                                                                                // "identifier" column of a typed

                                                                                // table (may be null)

                        "REF_GENERATION", // String => specifies how values in

                                                        // SELF_REFERENCING_COL_NAME are created. Values

                                                        // are "SYSTEM", "USER", "DERIVED". (may be

                                                        // null)

        };

        public void showTables() throws Exception {

                Connection conn = DriverManager.getConnection(

                                "jdbc:postgresql://localhost/gvsigDB", "gvsig", "gvsig");

                try {

                        // Statement st = conn.createStatement();

                        // String sql = "select tablename from pg_tables";

                        // ResultSet result = st.executeQuery(sql);

                        DatabaseMetaData metadata = conn.getMetaData();

                        ResultSet result = metadata.getTables(null, null, null,

                                        new String[] { "TABLE", "VIEW" });

                        ResultSetMetaData resultMD = result.getMetaData();

                        String[] columns = new String[resultMD.getColumnCount()];

                        for (int i = 0; i < columns.length; i++) {

                                columns[i] = resultMD.getColumnName(i + 1);

                        }

                        for (int i = 0; i < columns.length; i++) {

                                System.out.print(columns[i]);

                                System.out.print(";");

                        }

                        System.out.println();

                        while (result.next()) {

                                for (int i = 0; i < columns.length; i++) {

                                        System.out.print(result.getString(columns[i]));

                                        System.out.print(";");

                                }

                                System.out.println();

                        }

                } finally {

                        try {

                                conn.close();

                        } catch (SQLException e) {

                                e.printStackTrace();

                        }

                }

        }

        /**

         * @param args

         */

        public static void main(String[] args) {

                try {

                        new DatabaseMetadataChecks().showTables();

                } catch (Exception e) {

                        e.printStackTrace();

                        System.exit(-1);

                }

                System.exit(0);

        }

}