/* Delimiter changed to ; */
/* Connecting to localhost via PostgreSQL (experimental), username postgres, using password: Yes ... */
SELECT VERSION();
/* Connected. Thread-ID: 17860 */
SET statement_timeout TO 0;
SELECT EXTRACT(EPOCH FROM CURRENT_TIMESTAMP - pg_postmaster_start_time())::INTEGER;
SELECT "nspname" FROM "pg_catalog"."pg_namespace" ORDER BY "nspname";
SET SCHEMA 'public';
/* Entering session "WessERP Test Local" */
SELECT *, pg_table_size(QUOTE_IDENT(t.TABLE_SCHEMA) || '.' || QUOTE_IDENT(t.TABLE_NAME)) AS data_length, pg_relation_size(QUOTE_IDENT(t.TABLE_SCHEMA) || '.' || QUOTE_IDENT(t.TABLE_NAME)) AS index_length, c.reltuples, obj_description(c.oid) AS comment FROM "information_schema"."tables" AS t LEFT JOIN "pg_namespace" n ON t.table_schema = n.nspname LEFT JOIN "pg_class" c ON n.oid = c.relnamespace AND c.relname=t.table_name WHERE t."table_schema"='public';
/* Unknown datatype oid #1034 for "nspacl". Fall back to UNKNOWN. */
/* Unknown datatype oid #1034 for "relacl". Fall back to UNKNOWN. */
/* Unknown datatype oid #1009 for "reloptions". Fall back to UNKNOWN. */
SELECT "p"."proname" FROM "pg_catalog"."pg_namespace" AS "n" JOIN "pg_catalog"."pg_proc" AS "p" ON "p"."pronamespace" = "n"."oid" WHERE "n"."nspname"='public';
SELECT   DISTINCT a.attname AS column_name,   a.attnum,   a.atttypid,   FORMAT_TYPE(a.atttypid, a.atttypmod) AS data_type,   CASE a.attnotnull WHEN false THEN 'YES' ELSE 'NO' END AS IS_NULLABLE,   com.description AS column_comment,   def.adsrc AS column_default,   NULL AS character_maximum_length FROM pg_attribute AS a JOIN pg_class AS pgc ON pgc.oid = a.attrelid LEFT JOIN pg_description AS com ON (pgc.oid = com.objoid AND a.attnum = com.objsubid) LEFT JOIN pg_attrdef AS def ON (a.attrelid = def.adrelid AND a.attnum = def.adnum) WHERE   a.attnum > 0   AND pgc.oid = a.attrelid   AND pg_table_is_visible(pgc.oid)   AND NOT a.attisdropped   AND pgc.relname = 'XPUserSettingsAspect' ORDER BY a.attnum;
WITH ndx_list AS (SELECT pg_index.indexrelid FROM pg_index, pg_class WHERE pg_class.relname='XPUserSettingsAspect' AND pg_class.oid = pg_index.indrelid), ndx_cols AS (SELECT pg_class.relname, UNNEST(i.indkey) AS col_ndx, CASE i.indisprimary WHEN true THEN 'PRIMARY' ELSE CASE i.indisunique WHEN true THEN 'UNIQUE' ELSE 'KEY' END END AS CONSTRAINT_TYPE FROM pg_class, pg_index i WHERE pg_class.oid=i.indexrelid AND pg_class.oid IN (SELECT indexrelid FROM ndx_list) ) SELECT ndx_cols.relname AS CONSTRAINT_NAME, ndx_cols.CONSTRAINT_TYPE, a.attname AS COLUMN_NAME FROM pg_class c, pg_attribute a JOIN ndx_cols ON (a.attnum=ndx_cols.col_ndx) WHERE c.oid='XPUserSettingsAspect'::regclass AND a.attrelid=c.oid;
/* ERROR:  relation "xpusersettingsaspect" does not exist
LINE 1: ...x_cols ON (a.attnum=ndx_cols.col_ndx) WHERE c.oid='XPUserSet...
                                                             ^ */
/* ERROR:  relation "xpusersettingsaspect" does not exist
LINE 1: ...x_cols ON (a.attnum=ndx_cols.col_ndx) WHERE c.oid='XPUserSet...
                                                             ^ */
SELECT   DISTINCT a.attname AS column_name,   a.attnum,   a.atttypid,   FORMAT_TYPE(a.atttypid, a.atttypmod) AS data_type,   CASE a.attnotnull WHEN false THEN 'YES' ELSE 'NO' END AS IS_NULLABLE,   com.description AS column_comment,   def.adsrc AS column_default,   NULL AS character_maximum_length FROM pg_attribute AS a JOIN pg_class AS pgc ON pgc.oid = a.attrelid LEFT JOIN pg_description AS com ON (pgc.oid = com.objoid AND a.attnum = com.objsubid) LEFT JOIN pg_attrdef AS def ON (a.attrelid = def.adrelid AND a.attnum = def.adnum) WHERE   a.attnum > 0   AND pgc.oid = a.attrelid   AND pg_table_is_visible(pgc.oid)   AND NOT a.attisdropped   AND pgc.relname = 'XPUserSettingsAspect' ORDER BY a.attnum;
WITH ndx_list AS (SELECT pg_index.indexrelid FROM pg_index, pg_class WHERE pg_class.relname='XPUserSettingsAspect' AND pg_class.oid = pg_index.indrelid), ndx_cols AS (SELECT pg_class.relname, UNNEST(i.indkey) AS col_ndx, CASE i.indisprimary WHEN true THEN 'PRIMARY' ELSE CASE i.indisunique WHEN true THEN 'UNIQUE' ELSE 'KEY' END END AS CONSTRAINT_TYPE FROM pg_class, pg_index i WHERE pg_class.oid=i.indexrelid AND pg_class.oid IN (SELECT indexrelid FROM ndx_list) ) SELECT ndx_cols.relname AS CONSTRAINT_NAME, ndx_cols.CONSTRAINT_TYPE, a.attname AS COLUMN_NAME FROM pg_class c, pg_attribute a JOIN ndx_cols ON (a.attnum=ndx_cols.col_ndx) WHERE c.oid='XPUserSettingsAspect'::regclass AND a.attrelid=c.oid;
/* ERROR:  relation "xpusersettingsaspect" does not exist
LINE 1: ...x_cols ON (a.attnum=ndx_cols.col_ndx) WHERE c.oid='XPUserSet...
                                                             ^ */
/* ERROR:  relation "xpusersettingsaspect" does not exist
LINE 1: ...x_cols ON (a.attnum=ndx_cols.col_ndx) WHERE c.oid='XPUserSet...
                                                             ^ */
SELECT   DISTINCT a.attname AS column_name,   a.attnum,   a.atttypid,   FORMAT_TYPE(a.atttypid, a.atttypmod) AS data_type,   CASE a.attnotnull WHEN false THEN 'YES' ELSE 'NO' END AS IS_NULLABLE,   com.description AS column_comment,   def.adsrc AS column_default,   NULL AS character_maximum_length FROM pg_attribute AS a JOIN pg_class AS pgc ON pgc.oid = a.attrelid LEFT JOIN pg_description AS com ON (pgc.oid = com.objoid AND a.attnum = com.objsubid) LEFT JOIN pg_attrdef AS def ON (a.attrelid = def.adrelid AND a.attnum = def.adnum) WHERE   a.attnum > 0   AND pgc.oid = a.attrelid   AND pg_table_is_visible(pgc.oid)   AND NOT a.attisdropped   AND pgc.relname = 'XPUserSettingsAspect' ORDER BY a.attnum;
WITH ndx_list AS (SELECT pg_index.indexrelid FROM pg_index, pg_class WHERE pg_class.relname='XPUserSettingsAspect' AND pg_class.oid = pg_index.indrelid), ndx_cols AS (SELECT pg_class.relname, UNNEST(i.indkey) AS col_ndx, CASE i.indisprimary WHEN true THEN 'PRIMARY' ELSE CASE i.indisunique WHEN true THEN 'UNIQUE' ELSE 'KEY' END END AS CONSTRAINT_TYPE FROM pg_class, pg_index i WHERE pg_class.oid=i.indexrelid AND pg_class.oid IN (SELECT indexrelid FROM ndx_list) ) SELECT ndx_cols.relname AS CONSTRAINT_NAME, ndx_cols.CONSTRAINT_TYPE, a.attname AS COLUMN_NAME FROM pg_class c, pg_attribute a JOIN ndx_cols ON (a.attnum=ndx_cols.col_ndx) WHERE c.oid='XPUserSettingsAspect'::regclass AND a.attrelid=c.oid;
/* ERROR:  relation "xpusersettingsaspect" does not exist
LINE 1: ...x_cols ON (a.attnum=ndx_cols.col_ndx) WHERE c.oid='XPUserSet...
                                                             ^ */
/* ERROR:  relation "xpusersettingsaspect" does not exist
LINE 1: ...x_cols ON (a.attnum=ndx_cols.col_ndx) WHERE c.oid='XPUserSet...
                                                             ^ */
SELECT   DISTINCT a.attname AS column_name,   a.attnum,   a.atttypid,   FORMAT_TYPE(a.atttypid, a.atttypmod) AS data_type,   CASE a.attnotnull WHEN false THEN 'YES' ELSE 'NO' END AS IS_NULLABLE,   com.description AS column_comment,   def.adsrc AS column_default,   NULL AS character_maximum_length FROM pg_attribute AS a JOIN pg_class AS pgc ON pgc.oid = a.attrelid LEFT JOIN pg_description AS com ON (pgc.oid = com.objoid AND a.attnum = com.objsubid) LEFT JOIN pg_attrdef AS def ON (a.attrelid = def.adrelid AND a.attnum = def.adnum) WHERE   a.attnum > 0   AND pgc.oid = a.attrelid   AND pg_table_is_visible(pgc.oid)   AND NOT a.attisdropped   AND pgc.relname = 'XPUserSettingsAspect' ORDER BY a.attnum;
WITH ndx_list AS (SELECT pg_index.indexrelid FROM pg_index, pg_class WHERE pg_class.relname='XPUserSettingsAspect' AND pg_class.oid = pg_index.indrelid), ndx_cols AS (SELECT pg_class.relname, UNNEST(i.indkey) AS col_ndx, CASE i.indisprimary WHEN true THEN 'PRIMARY' ELSE CASE i.indisunique WHEN true THEN 'UNIQUE' ELSE 'KEY' END END AS CONSTRAINT_TYPE FROM pg_class, pg_index i WHERE pg_class.oid=i.indexrelid AND pg_class.oid IN (SELECT indexrelid FROM ndx_list) ) SELECT ndx_cols.relname AS CONSTRAINT_NAME, ndx_cols.CONSTRAINT_TYPE, a.attname AS COLUMN_NAME FROM pg_class c, pg_attribute a JOIN ndx_cols ON (a.attnum=ndx_cols.col_ndx) WHERE c.oid='XPUserSettingsAspect'::regclass AND a.attrelid=c.oid;
/* ERROR:  relation "xpusersettingsaspect" does not exist
LINE 1: ...x_cols ON (a.attnum=ndx_cols.col_ndx) WHERE c.oid='XPUserSet...
                                                             ^ */
/* ERROR:  relation "xpusersettingsaspect" does not exist
LINE 1: ...x_cols ON (a.attnum=ndx_cols.col_ndx) WHERE c.oid='XPUserSet...
                                                             ^ */
SELECT   DISTINCT a.attname AS column_name,   a.attnum,   a.atttypid,   FORMAT_TYPE(a.atttypid, a.atttypmod) AS data_type,   CASE a.attnotnull WHEN false THEN 'YES' ELSE 'NO' END AS IS_NULLABLE,   com.description AS column_comment,   def.adsrc AS column_default,   NULL AS character_maximum_length FROM pg_attribute AS a JOIN pg_class AS pgc ON pgc.oid = a.attrelid LEFT JOIN pg_description AS com ON (pgc.oid = com.objoid AND a.attnum = com.objsubid) LEFT JOIN pg_attrdef AS def ON (a.attrelid = def.adrelid AND a.attnum = def.adnum) WHERE   a.attnum > 0   AND pgc.oid = a.attrelid   AND pg_table_is_visible(pgc.oid)   AND NOT a.attisdropped   AND pgc.relname = 'XPUserSettingsAspect' ORDER BY a.attnum;
WITH ndx_list AS (SELECT pg_index.indexrelid FROM pg_index, pg_class WHERE pg_class.relname='XPUserSettingsAspect' AND pg_class.oid = pg_index.indrelid), ndx_cols AS (SELECT pg_class.relname, UNNEST(i.indkey) AS col_ndx, CASE i.indisprimary WHEN true THEN 'PRIMARY' ELSE CASE i.indisunique WHEN true THEN 'UNIQUE' ELSE 'KEY' END END AS CONSTRAINT_TYPE FROM pg_class, pg_index i WHERE pg_class.oid=i.indexrelid AND pg_class.oid IN (SELECT indexrelid FROM ndx_list) ) SELECT ndx_cols.relname AS CONSTRAINT_NAME, ndx_cols.CONSTRAINT_TYPE, a.attname AS COLUMN_NAME FROM pg_class c, pg_attribute a JOIN ndx_cols ON (a.attnum=ndx_cols.col_ndx) WHERE c.oid='XPUserSettingsAspect'::regclass AND a.attrelid=c.oid;
/* ERROR:  relation "xpusersettingsaspect" does not exist
LINE 1: ...x_cols ON (a.attnum=ndx_cols.col_ndx) WHERE c.oid='XPUserSet...
                                                             ^ */
/* ERROR:  relation "xpusersettingsaspect" does not exist
LINE 1: ...x_cols ON (a.attnum=ndx_cols.col_ndx) WHERE c.oid='XPUserSet...
                                                             ^ */
SELECT   DISTINCT a.attname AS column_name,   a.attnum,   a.atttypid,   FORMAT_TYPE(a.atttypid, a.atttypmod) AS data_type,   CASE a.attnotnull WHEN false THEN 'YES' ELSE 'NO' END AS IS_NULLABLE,   com.description AS column_comment,   def.adsrc AS column_default,   NULL AS character_maximum_length FROM pg_attribute AS a JOIN pg_class AS pgc ON pgc.oid = a.attrelid LEFT JOIN pg_description AS com ON (pgc.oid = com.objoid AND a.attnum = com.objsubid) LEFT JOIN pg_attrdef AS def ON (a.attrelid = def.adrelid AND a.attnum = def.adnum) WHERE   a.attnum > 0   AND pgc.oid = a.attrelid   AND pg_table_is_visible(pgc.oid)   AND NOT a.attisdropped   AND pgc.relname = 'XPUserSettingsAspect' ORDER BY a.attnum;
WITH ndx_list AS (SELECT pg_index.indexrelid FROM pg_index, pg_class WHERE pg_class.relname='XPUserSettingsAspect' AND pg_class.oid = pg_index.indrelid), ndx_cols AS (SELECT pg_class.relname, UNNEST(i.indkey) AS col_ndx, CASE i.indisprimary WHEN true THEN 'PRIMARY' ELSE CASE i.indisunique WHEN true THEN 'UNIQUE' ELSE 'KEY' END END AS CONSTRAINT_TYPE FROM pg_class, pg_index i WHERE pg_class.oid=i.indexrelid AND pg_class.oid IN (SELECT indexrelid FROM ndx_list) ) SELECT ndx_cols.relname AS CONSTRAINT_NAME, ndx_cols.CONSTRAINT_TYPE, a.attname AS COLUMN_NAME FROM pg_class c, pg_attribute a JOIN ndx_cols ON (a.attnum=ndx_cols.col_ndx) WHERE c.oid='XPUserSettingsAspect'::regclass AND a.attrelid=c.oid;
/* ERROR:  relation "xpusersettingsaspect" does not exist
LINE 1: ...x_cols ON (a.attnum=ndx_cols.col_ndx) WHERE c.oid='XPUserSet...
                                                             ^ */
/* ERROR:  relation "xpusersettingsaspect" does not exist
LINE 1: ...x_cols ON (a.attnum=ndx_cols.col_ndx) WHERE c.oid='XPUserSet...
                                                             ^ */