Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tzqET-007QAW-P2 for pgsql-admin@arkaria.postgresql.org; Wed, 02 Apr 2025 05:01:45 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tzqES-009pZI-49 for pgsql-admin@arkaria.postgresql.org; Wed, 02 Apr 2025 05:01:44 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tzqER-009pYC-Ot for pgsql-admin@lists.postgresql.org; Wed, 02 Apr 2025 05:01:43 +0000 Received: from mail-oa1-x33.google.com ([2001:4860:4864:20::33]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1tzqEP-002UN9-3D for pgsql-admin@lists.postgresql.org; Wed, 02 Apr 2025 05:01:42 +0000 Received: by mail-oa1-x33.google.com with SMTP id 586e51a60fabf-2c6ed7efb1dso4053333fac.2 for ; Tue, 01 Apr 2025 22:01:41 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1743570101; x=1744174901; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=3oRhivYdiulhF7Ct9j5Hl0H/gZqZ3WGYz6GJLPvsunc=; b=guEUJ5G5ZSAeHynScHpGog8Mq5rwv+d9stlH7jtGWJL7OdBz970lohz4bzEazZBIb5 mDx8Uzm1t03fNPFXws54mBCqrXK1RpHnrT5QkUI+yLxjn6TtzvWCLlr9Lywr/Np3bq4p Rlkd5oHARJNHNTb7slgB5oWRPmfPkjlOHoyiykFuThiGFchx+IGhGkpXWACvpGbKuR4F 7xL3iP/vRYRByHKJpqLAwUVPb763j3rwRwAH33wqQRbVlfbW8iy/fiZt/yQap3UTXDjY fnctKmW/+kjGZePIMB1C+XcpALvnf87KNYuQ7LSwcDLBUP/0UyLXbsvhPJidhJUW1sA8 VulA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1743570101; x=1744174901; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=3oRhivYdiulhF7Ct9j5Hl0H/gZqZ3WGYz6GJLPvsunc=; b=IClv7aKV+52nzCnnaMX4i6ULLfc7bAGCCh7pWxFogFcNqgC0/RdvmsyNcaZRFppfSI 3NQY5OBoNIYmNSNjujKtFP29vYX3KMDHHU/clm+pPKktpcQiW4bH/m1cq5GopwHpd2aX hG2kLo3RMFcfrsgkjE1h0K7Bqn5JbOQYMdSPgtvpEfq+1owcYV1xjEt9n7sbx3tO6NCd vZj6HiIJWW5ib1s/b4NPB7A5s2fliIEifsp4RIxs4X67qshH0XbYuJAlgICsEj7B+C9a NZ09nsk7wxOcjpc/FMoUhlLTWIN+3cmB8CqwEVgpXCUMJC2vDd0n0yzBnlbkqjym80DT Uqrw== X-Gm-Message-State: AOJu0YzcnDDTyfpTUKfvr1zRlPDHgTj+362w3/ZL/ImQ6U3KFygeVxqp qTLXYJiUE4MiMG8nXkI+HmKTadrgWKO07odGOuIGO7b/lfC7dcpLd1gWgNvp9uSimMndDhDwGu6 weduzehVF0eTz8TwNjC1M8mQbScY= X-Gm-Gg: ASbGncu6/wr4fYJlCUzgybbo4OgmYORHASYxf/j7trXjgQy6GVIv7E3gzcfUB9HG8AG xIkzU87jcEibHNLnKhky/NDoiY/06uC2yuXMsbHIwrcJP7B6W4LppXg/xJHIU6Yd6Mq68OSYGr7 HrI4CdjKV885t0KQBjWSlYSVJE X-Google-Smtp-Source: AGHT+IEUFRvdwydXOphbWA1SxKsw6TomtrVRmUD168/Y7COafygOVHoDGcYJoYQn8iKmzQUBYluWdRLB5dyqA5UPDAY= X-Received: by 2002:a05:6870:d149:b0:2a7:d345:c0bb with SMTP id 586e51a60fabf-2cbcf73d043mr9820903fac.27.1743570101151; Tue, 01 Apr 2025 22:01:41 -0700 (PDT) MIME-Version: 1.0 Received: by 2002:ac9:53c2:0:b0:589:13f9:e937 with HTTP; Tue, 1 Apr 2025 22:01:40 -0700 (PDT) In-Reply-To: References: From: "David G. Johnston" Date: Tue, 1 Apr 2025 22:01:40 -0700 X-Gm-Features: AQ5f1JpJU1bZdaDhAg8zrPeHPBZZ-7VI6k2KoQ9gi1mISxYlv8ZXJ59UlXMcEDw Message-ID: Subject: Re: psql formatting question To: Edwin UY Cc: Pgsql-admin Content-Type: multipart/alternative; boundary="0000000000008535a10631c48c1a" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000008535a10631c48c1a Content-Type: text/plain; charset="UTF-8" On Tuesday, April 1, 2025, Edwin UY wrote: > > Are there any psql settings that I can set to format the output for below > so that the output of settings is wrapped sort of? > Try replacing commas with newlines and see if that result works better for you. > > rds.allowed_extensions | * > rds.extensions | address_standardizer, > address_standardizer_data_us, amcheck, autoinc, aws_commons, aws_lambda, > aws_s3, bloom, bool > _plperl, btree_gin, btree_gist, citext, cube, dblink, dict_int, dict_xsyn, > earthdistance, flow_control, fuzzystrmatch, h3, > > Hoping to get the output like below maybe or something close to it. > > name | setting > rds.allowed_delegated_extensions | > rds.allowed_extensions | * > rds.extensions | address_standardizer, > address_standardizer_data_us, amcheck, autoinc, aws_commons, aws_lambda, > aws_s3, bloom, bool_plperl, > btree_gin, btree_gist, citext, cube, > dblink, dict_int, dict_xsyn, earthdistance, flow_control, > David J. --0000000000008535a10631c48c1a Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Tuesday, April 1, 2025, Edwin UY <edwin.uy@gmail.com> wrote:

Are there any psql settings that I= can set to format the output for below so that the output of settings is w= rapped sort of?

T= ry replacing commas with newlines and see if that result works better for y= ou.
=C2=A0
<= div>

= =C2=A0rds.allowed_extensions =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 | *
=C2=A0rds.extensions =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 | address_standardizer, address_standardizer_data_us, = amcheck, autoinc, aws_commons, aws_lambda, aws_s3, bloom, bool
_plperl, = btree_gin, btree_gist, citext, cube, dblink, dict_int, dict_xsyn, earthdist= ance, flow_control, fuzzystrmatch, h3,

Ho= ping to get the output like below maybe or something close to it.

=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0name =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 | =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 sett= ing
=C2=A0rds.allowed_delegated_extensions |
=C2=A0rds.allowed_e= xtensions =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 | *
=C2=A0rds.extensions = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 | address_st= andardizer, address_standardizer_data_us, amcheck, autoinc, aws_commons, aw= s_lambda, aws_s3, bloom, bool_plperl,
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 btree_gin, btree_gist, citext, cube, dblink, dict_int,= dict_xsyn, earthdistance, flow_control,

David J.
=C2=A0
--0000000000008535a10631c48c1a--