Without writing database name on session manager and selecting it on left panel: ġ9 Jun - ansgar: Silent Installation files/documentsġ7 Jun - ansgar: Character encoding issues at column name. ![]() ID de Hilo: 2794 */ SET statement_timeout TO 0 Writing database name on session manager and selecting it on left panel: ', t.TABLE_NAME)) AS index_length, c.reltuples, obj_description(c.oid) AS comment FROM "information_schema"."tables" AS t LEFT JOIN "pg_class" c ON c.relname=t.table_name LEFT JOIN "pg_namespace" n ON (n.oid = c.relnamespace) WHERE t."table_schema"=' public' SELECT "schema_name" FROM "information_schema"."schemata" ORDER BY "schema_name" SELECT EXTRACT(EPOCH FROM CURRENT_TIMESTAMP - pg_postmaster_start_time())::INTEGER ID de Hilo: 2728 */ SET statement_timeout TO 0 * Delimitador cambiado a */ /* Conectando a localhost por PostgreSQL (experimental), usuario postgres, usando contraseña: Yes. * Entrando a la sesión "localhost PGSQL" */ SELECT *, pg_table_size( CONCAT(t.TABLE_SCHEMA, '. ![]() ![]() Understanding, the structure of the table I took from heidisql and in fact it looks like this: Structure of the table when viewing that there is an error: ', t.TABLE_NAME)) AS index_length, c.reltuples, obj_description(c.oid) AS comment FROM "information_schema"."tables" AS t LEFT JOIN "pg_class" c ON c.relname=t.table_name LEFT JOIN "pg_namespace" n ON (n.oid = c.relnamespace) WHERE t."table_schema"=' sapcine' ', t.TABLE_NAME)) AS data_length, pg_relation_size( CONCAT(t.TABLE_SCHEMA, '.
0 Comments
Leave a Reply. |