From b8beae97f2cf88a405001b1f4a51434e944c776e Mon Sep 17 00:00:00 2001 From: James Barnett Date: Wed, 28 Feb 2018 21:49:32 +0000 Subject: Remove cross-schema autocomplete until it can be improved Add pg database param to new connection config --- query-executor.js | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) (limited to 'query-executor.js') diff --git a/query-executor.js b/query-executor.js index b9fb561..6ae9f4f 100644 --- a/query-executor.js +++ b/query-executor.js @@ -12,7 +12,7 @@ const connectionConfig = remote.getCurrentWindow().connectionConfig; const connectionPool = new Pool({ user: connectionConfig.username, host: connectionConfig.host, - database: "postgres", + database: connectionConfig.database, password: connectionConfig.password, port: connectionConfig.port }); @@ -56,9 +56,9 @@ ipcRenderer.on("queryExecutor.queryTableMetadata", (event, payload) => { let tableMetadata = {}; let tableDataQuery = - "SELECT c.table_schema || '.' || c.table_name identifier, c.column_name " + + "SELECT c.table_name identifier, c.column_name " + "FROM information_schema.columns c " + - "WHERE c.table_schema != 'pg_catalog'"; + "WHERE c.table_schema = current_schema()"; connectionPool.query(tableDataQuery, (err, res) => { -- cgit v1.2.3