Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pNUeV-0007T3-0c for pgsql-general@arkaria.postgresql.org; Thu, 02 Feb 2023 08:09:03 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pNUeU-0006fr-0z for pgsql-general@arkaria.postgresql.org; Thu, 02 Feb 2023 08:09:02 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pNUeT-0006eA-Bd for pgsql-general@lists.postgresql.org; Thu, 02 Feb 2023 08:09:01 +0000 Received: from mail-psaapc01on2130.outbound.protection.outlook.com ([40.107.255.130] helo=APC01-PSA-obe.outbound.protection.outlook.com) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pNUeP-00025W-TQ for pgsql-general@lists.postgresql.org; Thu, 02 Feb 2023 08:09:00 +0000 ARC-Seal: i=2; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=pass; b=ZaeqxYGuBCS9PRXyuhPtA4Cuia+cpYqWOZcXVFO53WRJWL0DrK9dSvzurnqCJm6eO0eGwIMCDDzOkuq/o6F80yW7HZHj+2+z+czNsIyMRZwoJp/oshUIq4k8sR3ZvzdeZ0/hPaNSrzy52wFHrCspxoaGnqFRximcZm/y8f9pnJ6GhjoARa4Ix0vrZ3+fNHPJ0F1cGULg8XTZ+rIacl9CEmPAEBOmjP8mogVJ+8wqQ3KoLx5bo7c35sPVS0jEC9L0s2nXipA/7fGVepNTige8A2BI7eCAzGnOCjNLcYchNF7odCrD6K0sish3EuX7eBgYZ+KhoyyB4JTGevgbF+qKew== ARC-Message-Signature: i=2; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector9901; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1; bh=QTDwqwiU87NBVGBcDTHy0SzvjHw2B+mtREOIhcVaH/s=; b=TXrt3gmSsdN56xdYVrJ4LxLHxdqBPNrVTtK2yLqtbbRrc8Bq3PGlelJ4XDww/c8YoSVTH3335RoUMygn3vbIfTRBaRF/3hO3/LJjWEW8lbt/mVPPTNAghLuLPSevQ5up8cASLqJLpIurSpu+BPOg7+WI84CQ32KGZkudAlTgAMfULMxVpmUVYy/iadpl1LT0jpdox4fcIt6KMgZtXF+vBo3+/wlm5wqhqrJgoXHsElJGP1BZZDLAyrwr/Uh2fK+fdUvQLGpNctM7fgvAtiraawRuIa9jN0A1VN1T2s2JwPUPKYN+KqeR0rgLsFlKFII5Xa/slhYeRUP4ecnPQ91r1w== ARC-Authentication-Results: i=2; mx.microsoft.com 1; spf=pass (sender ip is 104.47.26.105) smtp.rcpttodomain=es2000.it smtp.mailfrom=niwa.co.nz; dmarc=pass (p=none sp=none pct=100) action=none header.from=niwa.co.nz; dkim=pass (signature was verified) header.d=niwa.onmicrosoft.com; arc=pass (0 oda=1 ltdi=1 spf=[1,1,smtp.mailfrom=niwa.co.nz] dkim=[1,1,header.d=niwa.co.nz] dmarc=[1,1,header.from=niwa.co.nz]) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=niwa.onmicrosoft.com; s=selector1-niwa-onmicrosoft-com; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=QTDwqwiU87NBVGBcDTHy0SzvjHw2B+mtREOIhcVaH/s=; b=etmJS2QZ1YgOTRkECTeCIhJjnD/co77ovYFq3bVkbmaoNvX+5JiSL8u0/rI+w+ZV3h/unx9QH+zjNW7oeHWhp4aS80MN1F1D08ZigBYmPfZWXkuuPJq6M6s0c8Ks2VFRljPA7PVG7ag6NnvvmHSBT5nG91+mPtUydIFzz61wpxE= Received: from SYBPR01CA0082.ausprd01.prod.outlook.com (2603:10c6:10:3::22) by SYZPR01MB7588.ausprd01.prod.outlook.com (2603:10c6:10:16d::22) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.6064.22; Thu, 2 Feb 2023 08:08:48 +0000 Received: from ME3AUS01FT019.eop-AUS01.prod.protection.outlook.com (2603:10c6:10:3:cafe::43) by SYBPR01CA0082.outlook.office365.com (2603:10c6:10:3::22) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.6043.38 via Frontend Transport; Thu, 2 Feb 2023 08:08:48 +0000 X-MS-Exchange-Authentication-Results: spf=pass (sender IP is 104.47.26.105) smtp.mailfrom=niwa.co.nz; dkim=pass (signature was verified) header.d=niwa.onmicrosoft.com;dmarc=pass action=none header.from=niwa.co.nz; Received-SPF: Pass (protection.outlook.com: domain of niwa.co.nz designates 104.47.26.105 as permitted sender) receiver=protection.outlook.com; client-ip=104.47.26.105; helo=APC01-SG2-obe.outbound.protection.outlook.com; pr=C Received: from hamlmail.niwa.co.nz (103.229.249.34) by ME3AUS01FT019.mail.protection.outlook.com (10.114.155.186) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.6064.27 via Frontend Transport; Thu, 2 Feb 2023 08:08:47 +0000 Received: from APC01-SG2-obe.outbound.protection.outlook.com (mail-sgaapc01lp2105.outbound.protection.outlook.com [104.47.26.105]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (Client CN "mail.protection.outlook.com", Issuer "DigiCert Cloud Services CA-1" (not verified)) by hamlmail.niwa.co.nz (Postfix) with ESMTPS id E4D2A60518B; Thu, 2 Feb 2023 21:08:46 +1300 (NZDT) ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=oSX4w91V5VHBgcV7KMG7brRcS+U19Kv1qs1hvuqYZAtKYdOB0mmPWp4g14xjyEMCAmm4ydf3K4dLNapw55LWKMFpfyxD5Dvcy6ci33PThfG5u373J9h7N65ElNRDuAFwtsVffwl5gHyV5sK3OGtwYxcx2d2ov3cZ0Y80sPzs14846URxkLFaazifbBtRh1G+N/OJk0QMMA9sLP0x4KVOh/tF5bUNJT5vxjvfj0pi7h4/2HYFFiiBKToShpO3tp32RA8Swh6UxX18ExIHSEnqMaRjbY3alUiDejkCpVA8KtLljnH0VZVwpL/HiU3W+MhC0E/kk99UJHnAOUk2gWsd8g== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector9901; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1; bh=QTDwqwiU87NBVGBcDTHy0SzvjHw2B+mtREOIhcVaH/s=; b=Eybql59S2d2E7olOqgSKmj3viInS7/bW5dAtLLJaTHx+YfbtvFlh+0Uv9U6bsi20EbDV1vCeDzfZLrWc5TtXr2v63JUbNhK+UTVM3pu7miiKBt3JPTAj2AHOcNGL5LMvnSx+9FXNvKiZkmuwwBIzoTpsITNJk6aAaITiZNZPMl21S/OAwif3m2e433wma5DlsLcVc04hHOSwuML2n8GOBvSn/wsjx6302HADgOD8GBvWlBU+DbnODzOpAGtl4kdWZnqB5Ndb7FF9RnCgWdX4MDMYqRpxVHe2evUDvl7ib5sC9Se0R7CDwhjlA4PxQeYngGDuQYUPp9ofliDN+bpEkQ== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=niwa.co.nz; dmarc=pass action=none header.from=niwa.co.nz; dkim=pass header.d=niwa.co.nz; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=niwa.onmicrosoft.com; s=selector1-niwa-onmicrosoft-com; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=QTDwqwiU87NBVGBcDTHy0SzvjHw2B+mtREOIhcVaH/s=; b=etmJS2QZ1YgOTRkECTeCIhJjnD/co77ovYFq3bVkbmaoNvX+5JiSL8u0/rI+w+ZV3h/unx9QH+zjNW7oeHWhp4aS80MN1F1D08ZigBYmPfZWXkuuPJq6M6s0c8Ks2VFRljPA7PVG7ag6NnvvmHSBT5nG91+mPtUydIFzz61wpxE= Received: from SY4PR01MB7076.ausprd01.prod.outlook.com (2603:10c6:10:145::5) by SY6PR01MB8266.ausprd01.prod.outlook.com (2603:10c6:10:1d5::7) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.6086.6; Thu, 2 Feb 2023 08:08:44 +0000 Received: from SY4PR01MB7076.ausprd01.prod.outlook.com ([fe80::5dfe:cb00:d469:7b43]) by SY4PR01MB7076.ausprd01.prod.outlook.com ([fe80::5dfe:cb00:d469:7b43%9]) with mapi id 15.20.6086.006; Thu, 2 Feb 2023 08:08:44 +0000 From: Brent Wood To: Giovanni Biscontini , "pgsql-general@lists.postgresql.org" Subject: Re: Re-2: New to PostgreSQL - looking for query writing tools Thread-Topic: Re-2: New to PostgreSQL - looking for query writing tools Thread-Index: AQHZNt0extmJlrrrbE2KQDstLMlN4g== Date: Thu, 2 Feb 2023 08:08:44 +0000 Message-ID: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: msip_labels: Authentication-Results-Original: dkim=none (message not signed) header.d=none;dmarc=none action=none header.from=niwa.co.nz; x-ms-traffictypediagnostic: SY4PR01MB7076:EE_|SY6PR01MB8266:EE_|ME3AUS01FT019:EE_|SYZPR01MB7588:EE_ X-MS-Office365-Filtering-Correlation-Id: 8f19b993-b84b-40a8-7daa-08db04f4b654 x-niwa-seemail: Out X-MS-Exchange-SenderADCheck: 1 X-MS-Exchange-AntiSpam-Relay: 0 X-Microsoft-Antispam-Untrusted: BCL:0; X-Microsoft-Antispam-Message-Info-Original: Ts8xBI0mUMv9SqtAuumQoyJ1Witd0+QCrjum7ynvCc2rMCScXxXghvVO5TDB5Dj+MjWGZ4yod7vng6DZJggpXVbSi9aLNHLN1msGwMDbWbWHjbCB0NyFlX/izI5trDhImJ9ThqqsfeTf+iixwXZ6O7+BqfWzocLuvspYYo5hrT85yWuSueyedYgSvyRmlEPh9619UUd4JmhepSSaCfUBFcVijLiaT4dqGFIJi3wnMK4e5rknSKC9yzChV5gCR/pPVuoWsW0Z7tyUlrDWcSbYXzdUW/mvEzOWOpScCaA4LM1aAMkLhriQAcKKU/a64KQwv17GEmB6Cs0IEHx7+tA8FE9cXR/Wxhlf13UKSnpvUTnoeL3kiUbtqzSBfmOeFu/gnmbwPU5UgqCJpdapEGvxmzTuwE05HqRYjlMkrS54LiXMREVtHpEIO4H/L3hDubpboMr32Oxli9PcJdjaYe+Au5aAQ7tL6DlGE2PacLMAQV02f/ezfRZ1rYsNC3ig1pNSASieiY/4P6B00LIgRwuwdkz2QL3cxVG2uL+9QSxU9vPdxpH1SmvUEkNaq0DVqeAA7eOY6a7dFAkGTHb5ntpDTDSA/6lZvtUVjH4H3yZqwci4c+3fol36A9NPgSesbc3KYUbY+BwK7Xajh3NS4KhQBtvc1NtOR7yZBU6lwBCLys3O/+PFyhZN4DWxWRs68+wglKSo+OQS5chm2bKtWX/pTum55CX+kBVtINmUPSpvQOw= X-Forefront-Antispam-Report-Untrusted: CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:SY4PR01MB7076.ausprd01.prod.outlook.com;PTR:;CAT:NONE;SFS:(13230025)(4636009)(376002)(366004)(136003)(396003)(346002)(39860400002)(1690799011)(451199018)(19627405001)(66476007)(66574015)(66446008)(64756008)(9686003)(26005)(186003)(66946007)(5660300002)(76116006)(33656002)(6506007)(66556008)(66899018)(53546011)(83380400001)(8936002)(52536014)(966005)(45080400002)(38070700005)(71200400001)(166002)(478600001)(2906002)(122000001)(7696005)(38100700002)(8676002)(110136005)(41300700001)(86362001)(55016003)(316002);DIR:OUT;SFP:1102; Content-Type: multipart/alternative; boundary="_000_SY4PR01MB7076FC64091E68554E1BE679A1D69SY4PR01MB7076ausp_" MIME-Version: 1.0 X-MS-Exchange-Transport-CrossTenantHeadersStamped: SY6PR01MB8266 X-EOPAttributedMessage: 0 X-MS-Exchange-SkipListedInternetSender: ip=[104.47.26.105];domain=APC01-SG2-obe.outbound.protection.outlook.com X-MS-Exchange-ExternalOriginalInternetSender: ip=[104.47.26.105];domain=APC01-SG2-obe.outbound.protection.outlook.com X-MS-Exchange-Transport-CrossTenantHeadersStripped: ME3AUS01FT019.eop-AUS01.prod.protection.outlook.com X-MS-PublicTrafficType: Email X-MS-Office365-Filtering-Correlation-Id-Prvs: 1727c2f5-9e42-4147-facf-08db04f4b3f7 X-Microsoft-Antispam: BCL:0; X-Microsoft-Antispam-Message-Info: =?Windows-1252?Q?m0QVkom2sfFvT7ick+r9J+oaIS/AQdsWcGMEWd33j7k1y8/HHc3b5FMH?= =?Windows-1252?Q?JqpopuIWlILTwFBAh/ZmMDeqXPK4gxIzfza6goMC8RbvsracGr17Wtds?= =?Windows-1252?Q?HOX0aFh8nXmOCvnMNOF3ahlGkSeOfPyUyt6BwrjzC32EHPv39Ccqa4h5?= =?Windows-1252?Q?VO39TZMN4/VhJGQYQVyQUUcBaYD5S7hjynf11emU+a+RIXDghcp1qS2N?= =?Windows-1252?Q?GmrL7eBFGDZydBqCxfC8+7EVWX8KFZz5VBPd8ZBSY5abf5KeBus7hfwn?= =?Windows-1252?Q?YeoB0td6GBp8iLFGu76PJ8Gnstc1jbalkJ6KP5XB4eusElAYuW/f+BzR?= =?Windows-1252?Q?7i5FDbg7ugqFA1FIDfzmno8RLpytsUqNda3nXapSvsZacBabQ0QWXEOQ?= =?Windows-1252?Q?SNp2u+piuMwuhRWFrttu4DK7ROGGhmid784gqeeCXqdMRoTSv56MLYGT?= =?Windows-1252?Q?qwB3a5I7nuX1Uw5QdHmRXVVryha8aNHVDAIXLIp6vIoMWYFdlfFIlze2?= =?Windows-1252?Q?oLXQsd+cWpDfv5r+s6hztTp6bIB42/K3SBSkqlP0qI0Qo1HHp0hrw6UD?= =?Windows-1252?Q?rXihJbXviMJmCpcDTJ3sbnM8MzUH3g4p+C2gxZUFoI5oxDV0Kyo9XlBB?= =?Windows-1252?Q?VYiPlSsKJHRFbwurNHlgWQvDpr8JCG3SvFfzvVXohywHVZXB3F9M4SOQ?= =?Windows-1252?Q?6lwEVcj68s1Eg8Fs4+cw6cdN8eSgBlMOyDhUzXQ3CD5Hvnr/n+dK+Ria?= =?Windows-1252?Q?fMLk0VskVatkoUlAAXAmEdOY7fg85LKCIFwKdriP+PbXHyJcOntqQFxY?= =?Windows-1252?Q?yh/ZOUcf7fspKL3dgYbZAPwa2Z6h2L8rbURiAJVnm2QEgG5AYf0kP7In?= =?Windows-1252?Q?iyng/JahiBomv6aJM/pqkMhhhGTn/Hau6wKlsez5395cDi7Fdu++vxIA?= =?Windows-1252?Q?omeHkL5NPoXfoaA1cs3dteqRLTpmzDaPhTN/8dJtIAoIEZT3sb3IDvmw?= =?Windows-1252?Q?4dEkNKZgLeOCzNzm1zY/pZF+EE6Ys9qH5NP4Mm/F2wTpMHXTrHJwkbuP?= =?Windows-1252?Q?lveN8N/kX5rhudJYfnQiDl0juz6+dWE0/fc7S9mHvatHUYoCPj4HlM8Z?= =?Windows-1252?Q?lZVA7b1AX9Nl00IDE35NQ3ImPncFZDcUNzPL+xS9zPvvxg=3D=3D?= X-Forefront-Antispam-Report: CIP:103.229.249.34;CTRY:SG;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:APC01-SG2-obe.outbound.protection.outlook.com;PTR:mail-sgaapc01lp2105.outbound.protection.outlook.com;CAT:NONE;SFS:(13230025)(4636009)(136003)(346002)(376002)(39860400002)(396003)(7200799011)(451199018)(1690799011)(40470700004)(46966006)(36840700001)(2906002)(33656002)(40460700003)(70586007)(8676002)(316002)(66574015)(9686003)(186003)(26005)(83380400001)(47076005)(82310400005)(336012)(45080400002)(478600001)(7696005)(6506007)(53546011)(110136005)(966005)(55016003)(70206006)(40480700001)(156005)(166002)(86362001)(41300700001)(5660300002)(32850700003)(8936002)(36860700001)(7636003)(8400799011)(19627405001)(66899018)(82740400003)(52536014);DIR:OUT;SFP:1102; X-OriginatorOrg: niwa.co.nz X-MS-Exchange-CrossTenant-OriginalArrivalTime: 02 Feb 2023 08:08:47.9016 (UTC) X-MS-Exchange-CrossTenant-Network-Message-Id: 8f19b993-b84b-40a8-7daa-08db04f4b654 X-MS-Exchange-CrossTenant-Id: 41caed73-6a0c-468a-ba49-9ff6aafd1c77 X-MS-Exchange-CrossTenant-OriginalAttributedTenantConnectingIp: TenantId=41caed73-6a0c-468a-ba49-9ff6aafd1c77;Ip=[103.229.249.34];Helo=[hamlmail.niwa.co.nz] X-MS-Exchange-CrossTenant-AuthSource: ME3AUS01FT019.eop-AUS01.prod.protection.outlook.com X-MS-Exchange-CrossTenant-AuthAs: Anonymous X-MS-Exchange-CrossTenant-FromEntityHeader: HybridOnPrem X-MS-Exchange-Transport-CrossTenantHeadersStamped: SYZPR01MB7588 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_SY4PR01MB7076FC64091E68554E1BE679A1D69SY4PR01MB7076ausp_ Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable The free version of Valentina Studio and DBeaver are the two I prefer.... If you use Postgis for spatial data, DBeaver understands geometry data & ca= n display data on a simple map or as tabular output, with a built in Leafle= t facility. https://valentina-db.com/en/studio/download https://dbeaver.io/ Brent Wood ________________________________ From: Sacha Kerres Sent: Thursday, February 02, 2023 20:51 To: Giovanni Biscontini; pgsql-general@lists.postgresql.org Subject: Re-2: New to PostgreSQL - looking for query writing tools Hi, we use sqlmanager.net tools: Query, DBCompare, Data Compare, Automatic Tas= ks, Backup+Restore, etc... There is a free version, but for professional work, you have to buy a licen= se. But there is only a windows version. Mit freundlichen Gr=FC=DFen Sacha Kerres Kerres-EDV Beratung Deglhof 45-47 93142 Maxh=FCtte-Haidhof Tel. +49 9471 60 14 14 Mobil. +49 171 210 48 46 E-Mail. skerres@kerres-edv.de Original Message processed by david=AE Re: New to PostgreSQL - looking for query writing tools 2. Februar 2023, 08= :34 Uhr Von Giovanni Biscontini An pgsql-general@lists.postgresql.org Hi Troy, we both use pgAdmin4 and DBeaver (https://dbeaver.io/) Community version b= ut mainly 'cos we need to get in control of other functions of the database= server, query is only a part of the job. Another interesting tool is Aquaf= old (https://www.aquafold.com): Aqua Data Studio is interesting (only teste= d) but it's a bit pricey... Hope it helps, bye Giovanni Il giorno mer 1 feb 2023 alle ore 18:00 Robin Tang > ha scritto: There's a bunch listed here: https://wiki.postgresql.org/wiki/PostgreSQL_Cl= ients I personally use Postico, but it's only available on Mac. On Wed, Feb 1, 2023 at 8:43 AM Troy Sherven > wrote: Good morning, First of all, I am not a database professional. I work for a small company= , and a portion of my job includes report writing (crystal, i-Net, etc), Ex= cel analysis, etc. We recently migrated to a new ERP that runs on a Postgr= eSQL database. Our previous system was on a MSSQL database. I have fairly= basic experience writing SQL queries. In the past I would use Microsoft S= QL Server Management Studio to help in writing my SQL queries (I=92d use th= e diagram, criteria, and SQL panes) instead of just writing SQL statements. I=92m looking for recommendations of tools that would work similar to Micro= soft SQL Server Management Studio. So far I=92ve played around with pgAdmi= n (doesn=92t seem to have the same query writing abilities) and EMS SQL Que= ry (seems more cumbersome than the Microsoft tool). Are there any other to= ols I should be looking at for query writing help? I like to something visu= al and a grid to help write queries. Any recommendations would be appreciated! Troy -- Cordiali Saluti [https://ci3.googleusercontent.com/mail-sig/AIorK4wW12ZNDdF_BcmKN6zTAWE_BVe= y5jo0Vjx6DCd3Lh8QNf7OZ5pyIuCt8HHiwcR0LNmBay9NP-Y] Dott. Giovanni Biscontini [Divisone Software] Str. Ponte Alto Sud, 74 41123 Modena (MO) Phone: 059_452094 Fax: 059_8672171 E-mail: biscontini.g@es2000.it Skype: g.biscontini.eurosystem2000 WEB: https://www.es2000.it ____________________________________ Privacy e riservatezza: il presente messaggio, cos=EC come i relativi alleg= ati, contengono dati ed informazioni da considerarsi strettamente riservate= ed =E8 indirizzato esclusivamente al destinatario sopra indicato, il quale= =E8 l'unico autorizzato a trattarlo in osservanza delle norme del Regolame= nto UE 2016/679 (RGPD) . Preghiamo chiunque ricevesse questo messaggio per = errore di evitare di copiarlo, divulgarlo, distribuirlo a terzi e di dare n= otizia al mittente dell=92errato invio, distruggendone poi l'eventuale copi= a cartacea e la copia in formato elettronico. Il titolare dei dati potr=E0 esercitare tutti i diritti di cui all'art.7 de= l suddetto decreto tra cui quelli di accesso, rettifica, aggiornamento, opp= osizione al trattamento e cancellazione Please, print this e-mail only if necessary To: biscontini.g@es2000.it pgsql-general@lists.postgresql.org [https://www.niwa.co.nz/static/niwa-2018-horizontal-180.png] Brent Wood Principal Technician - GIS and Spatial Data Management Programme Leader - Environmental Information Delivery +64-4-386-0529 National Institute of Water & Atmospheric Research Ltd (NIWA) 301 Evans Bay Parade Hataitai Wellington New Zealand Connect with NIWA: niwa.co.nz Facebook LinkedIn Twitte= r Instagram To ensure compliance with legal requirements and to maintain cyber security= standards, NIWA's IT systems are subject to ongoing monitoring, activity l= ogging and auditing. This monitoring and auditing service may be provided b= y third parties. Such third parties can access information transmitted to, = processed by and stored on NIWA's IT systems --_000_SY4PR01MB7076FC64091E68554E1BE679A1D69SY4PR01MB7076ausp_ Content-Type: text/html; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable
The free version of Valentina Studio and DBeaver are the two I prefer....

If you use Postgis for spatial data, DBeaver understands geometry data &= ; can display data on a simple map or as tabular output, with a built in Le= aflet facility.



Brent Wood


From: Sacha Kerres
Sent: Thursday, February 02, 2023 20:51
To: Giovanni Biscontini; pgsql-general@lists.postgresql.org
Subject: Re-2: New to PostgreSQL - looking for query writing tools

Hi,
we use sqlmanager.net tools:  Query, DBCompare, Data Compare, Automati= c Tasks, Backup+Restore, etc...

There is a free version, but for professional work, you have to buy a licen= se. But there is only a windows version.

 
Mit freundlichen Gr=FC=DFen
 
Sacha Kerres
Kerres-EDV Beratung
Deglhof 45-47
93142 Maxh=FCtte-Haidhof
 
Tel. +49 9471 60 14 14
Mobil. +49 171 210 48 46
E-Mail. skerres@kerres-edv.de
 
 
 
Original Message processed= by david=AE
Re: New to PostgreSQL - looking for query writing tools 2. Februar= 2023, 08:34 Uhr
Von Giovanni Biscontini
An pgsql-general@lists.postgresql.org
Hi Troy, 
 we both use pgAdmin4 and DBeaver (https://dbeaver.io/) Community version but mainly 'cos we need to get = in control of other functions of the database server, query is only a part of the job. Another interesting tool is Aquafold (https://www.aquafo= ld.com): Aqua Data Studio is interesting (only tested) but it's a bit pricey...
Hope it helps, bye Giovanni 

Il giorno mer 1 feb 2023 alle ore 1= 8:00 Robin Tang <robin@artie.so> ha scritto:
There's a bunch listed here: https://wiki.postgresql.org/wiki/Pos= tgreSQL_Clients

I personally use Postico, but it's only available on Mac.

On Wed, Feb 1, 2023 at 8:43 AM Troy= Sherven <tsh= erven@mcd.net> wrote:

Good morning,

 

First of all, I am not a database professional= .  I work for a small company, and a portion of my job includes report= writing (crystal, i-Net, etc), Excel analysis, etc.  We recently migr= ated to a new ERP that runs on a PostgreSQL database.  Our previous system was on a MSSQL database.  I have = fairly basic experience writing SQL queries.  In the past I would use = Microsoft SQL Server Management Studio to help in writing my SQL queries (I= =92d use the diagram, criteria, and SQL panes) instead of just writing SQL statements. 

 

I=92m looking for recommendations of tools tha= t would work similar to Microsoft SQL Server Management Studio.  So fa= r I=92ve played around with pgAdmin (doesn=92t seem to have the same query = writing abilities) and EMS SQL Query (seems more cumbersome than the Microsoft tool).  Are there any other tools I sho= uld be looking at for query writing help? I like to something visual and a = grid to help write queries. 

 

Any recommendations would be appreciated!

 

Troy



--

 

 

Cordiali Saluti

&n= bsp;


&n= bsp;

 Dott. Giovanni Biscontini

 [D= ivisone Software]

&n= bsp;

 = Str. P= onte Alto Sud, 74 
  41123 Modena  (MO)

&n= bsp;Phone: 059_452094 
  Fax: 059_8672171
  E-mail: 
biscontini.g@es2000.it

&= nbsp;Skype: g.biscontini.eurosystem2000

 WE= B: https://www.es2= 000.it

&= nbsp;

 

 

____________________________________

Privacy e riservatezz= a: il presente messaggio, cos=EC come i relativi allegati, contengono dati = ed informazioni da considerarsi strettamente riservate ed =E8 indirizzato esclusivamente al destinatario sopra indicato= , il quale =E8 l'unico autorizzato a trattarlo in osservanza delle norme de= l Regolamento UE 2016/679 (RGPD) . Preghiamo chiunque ricevesse questo mess= aggio per errore di evitare di copiarlo, divulgarlo, distribuirlo a terzi e di dare notizia al mittente dell=92erra= to invio, distruggendone poi l'eventuale copia cartacea e la copia in forma= to elettronico.

Il titolare dei dati potr=E0 esercitare tutti = i diritti di cui all'art.7 del suddetto decreto tra cui quelli di accesso, = rettifica, aggiornamento, opposizione al trattamento e cancellazione

Please, print this e-mai= l only if necessary



To: biscontini.g@es2000.it
    pgsql-general@lists.postgresql.org
Brent Wood
Principal Technician - GIS and Spatial Data Managem= ent
Programme Leader - Environmental Information Delive= ry
+64-4-386-0529

National Institute of Water & Atmospheric Research Ltd (NIWA)
301 Evans Bay Parade Hataitai Wellington New Zealand
Connect with NIWA: niwa.co.nz= Facebook LinkedIn= Twitter Instagram
To ensure compliance with legal requirement= s and to maintain cyber security standards, NIWA's IT systems are subject t= o ongoing monitoring, activity logging and auditing. This monitoring and au= diting service may be provided by third parties. Such third parties can access information transmitted to, process= ed by and stored on NIWA's IT systems --_000_SY4PR01MB7076FC64091E68554E1BE679A1D69SY4PR01MB7076ausp_--