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 1pZbaQ-0002Zr-7M for pgsql-general@arkaria.postgresql.org; Tue, 07 Mar 2023 17:58:54 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pZbaO-0006sU-Ju for pgsql-general@arkaria.postgresql.org; Tue, 07 Mar 2023 17:58:52 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pZbaO-0006sL-6B for pgsql-general@lists.postgresql.org; Tue, 07 Mar 2023 17:58:52 +0000 Received: from mail-qt1-x82b.google.com ([2607:f8b0:4864:20::82b]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1pZbaK-0007H2-2f for pgsql-general@postgresql.org; Tue, 07 Mar 2023 17:58:50 +0000 Received: by mail-qt1-x82b.google.com with SMTP id cf14so15264713qtb.10 for ; Tue, 07 Mar 2023 09:58:47 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; t=1678211927; h=content-transfer-encoding:subject:from:content-language:to :user-agent:mime-version:date:message-id:from:to:cc:subject:date :message-id:reply-to; bh=Q+RnN6UenLFkEEswXSKoZZ1HvCtgnCX7mBvEmJ8S4Gc=; b=XjjrHRRpOHjWCIa/gs6WhekyWurLG1S4mx4VOeEx+ibufMm1oV/eCevPcp4ky/YoCL k678NB5fQWiB3tv21IraivTTQGqPnsy12gq5WfBFGecROWOYgMUttV3nGucJn21+fbl0 1dTWWdGwozK3EWEK+qAy9YBUEl328fQhdBZACQi1dP556+kSvF0cGz9MJIzw0I6in7V8 57gSYeOhDx+HEaJTWrXbWsxknR+NzT6ybNLOYuXZytGq7Z5XeLNWMdtCpoUFrV8XKww5 NERrWl4bvLJKNV+EEJghezW9Wev1YAxtTZjl/FRr0wWqjzqWY3YnhIElXTTsjckTP6nL JCyQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; t=1678211927; h=content-transfer-encoding:subject:from:content-language:to :user-agent:mime-version:date:message-id:x-gm-message-state:from:to :cc:subject:date:message-id:reply-to; bh=Q+RnN6UenLFkEEswXSKoZZ1HvCtgnCX7mBvEmJ8S4Gc=; b=k+LykkmV1jqdooF+cSAj2dE9W1awg/+m/lPCJjSZzY2bM9UNQa248Y/O0ByEz0HEOj m7SPsg1+0R00lZbZ+07aEfbGMxhRimcwqfvguodxdrHQPKt0aSIzYxqVkSa6Pi6a2yjo M6hi4v3haBv0ka4LQvNVxgWLUvczf2vDxPpWhlt1zDOLdIubjbcAnxz47EaQBdAsQUVX BqePMf9DkeedZRqbJcb6NeSLNvQE+GZoUEk982EvqJs9mvr1zfVH0kwIlryPt2KIDZ7O 7QcpSzPNZBbzExYRCAqm8ou76kPU3ktVlzpp3ZW0XaTdH3sM05z80ioOGXQxAoIvYpa+ 7Jfw== X-Gm-Message-State: AO0yUKXv7iyM6DjLmSEN7VkKqG7aZOcGDtxvgDsTAVCkGXAykgro2wjK ZI/ECoKAsmpRvhReXrAkzP0IexCDUIk= X-Google-Smtp-Source: AK7set80KhaaK5fdJmTzdwjFZzOAiT6vP262xY7mKEpkrtzhihRWAxRPNUdAwYxgEhJ1sozay20zQA== X-Received: by 2002:ac8:5e0f:0:b0:3ba:1d8d:f6eb with SMTP id h15-20020ac85e0f000000b003ba1d8df6ebmr26846076qtx.58.1678211926871; Tue, 07 Mar 2023 09:58:46 -0800 (PST) Received: from ?IPV6:2600:1700:bd2c:b810::43? ([2600:1700:bd2c:b810::43]) by smtp.googlemail.com with ESMTPSA id j63-20020a37b942000000b0073b3316bbd0sm9920485qkf.29.2023.03.07.09.58.46 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Tue, 07 Mar 2023 09:58:46 -0800 (PST) Message-ID: <4eed5377-3603-85b9-965e-f2bcd507c045@gmail.com> Date: Tue, 7 Mar 2023 11:58:45 -0600 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.4.2 To: pgsql-general@postgresql.org Content-Language: en-US From: Ron Subject: psql \conninfo in tabular form? Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk v13.10 Instead of a sentence like this: You are connected to database "postgres" as user "postgres" via socket in "/var/run/postgresql" at port "5433". I'd rather have something tabular like:    keyword  |   value ------------+-----------------------   database  | postgres   user      | postgres   host      | /var/run/postgresql   port      |  5433 Running psql with the -E option didn't help.  There's a github project named ibarwick/conninfo which looked useful, but it seems to only parse connection strings. -- Born in Arizona, moved to Babylonia.