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 1tzxtU-009IWB-3l for pgsql-admin@arkaria.postgresql.org; Wed, 02 Apr 2025 13:12:36 +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 1tzxtS-00Db48-S4 for pgsql-admin@arkaria.postgresql.org; Wed, 02 Apr 2025 13:12:34 +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 1tzxtS-00Db3x-C8 for pgsql-admin@lists.postgresql.org; Wed, 02 Apr 2025 13:12:34 +0000 Received: from mail-oo1-xc2b.google.com ([2607:f8b0:4864:20::c2b]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1tzxtQ-002YLc-1c for pgsql-admin@lists.postgresql.org; Wed, 02 Apr 2025 13:12:33 +0000 Received: by mail-oo1-xc2b.google.com with SMTP id 006d021491bc7-5fc6cd89f85so3607324eaf.1 for ; Wed, 02 Apr 2025 06:12:32 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1743599551; x=1744204351; darn=lists.postgresql.org; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :from:to:cc:subject:date:message-id:reply-to; bh=p/QycLjjiogUZAtj4aASLw6L8k/T/nA+SLCjOXtFpTA=; b=UC2VYekkfVV6CdhcZneWa4TwiaFCh5t6BSoobmtD+Z8W0sPYR3cKyfCJLkoOunxCND Uba3ZLg2GQ9Pq64eH/6ga2Uevi6s8peylDY+T1W2kNCsBanT38RMprgDJ4MGGX/CaQxb fnWywAEL+D2cZ0LMhd+Dwq0yqVNKk9XqkLNZDdKRD9IizR4uXSM9+SwgkCOW8sy8anWN xIKZQGNstCS2dW3/fyqoCzKaBTtW+EahoVDCXSuqDVFL4zx0so2CwVmA5d0g+mgN0Hag E9YiZfAVS9smHWJAxSumftD7/rJSR0lmyFfInVSOI7UyjsNCv/hfSQp6q2W1pWPNZE5X BV6g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1743599551; x=1744204351; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=p/QycLjjiogUZAtj4aASLw6L8k/T/nA+SLCjOXtFpTA=; b=E+QUmTQqd3pCWE3su6F7TPNYNy2VrnCYKbAz6/4GHXIb5Y7FMuQB/TUoycw4fvaMTk ROvrNDmnDg2JRvIEaPw/uEJuT0UPLd7EbF+6O/zLIJepgkPhN9gV1a1H1q95RpUgr4OJ eWU6doZcNQcw/UsQTUZ/KCL/np2xSIrRodkvvekCIFN5iqdBvLuqNVmSDKu8I9KqPwoO r6fIvXOVRI0CFVN64Wik3MDmr1MDjeiSe7WNqeeQc2b1UxzKarAwqWmb7A45VdyMLy7X IuC2VVdBXRYZ7gmc4OVG5akCsHC0okr+oLxN5JYzWoTR0RepPmkUn/cHpo9xuYeRUiBs maKg== X-Gm-Message-State: AOJu0YySzUzYMx9d+YPmQ7Zy2WeCfmryyqEJYswSmJ/NCf1JFIdJq7dl pW6SET+JxfPBHEvnc/dvZzMwV6FGqBsYb8hLsTWDML7NTMrgeGQtDr+SalQZ1XWluEuE47uh37m u27+tPhPeT4/eYc1GcUxYa4SoliNGAw== X-Gm-Gg: ASbGncsxSdlVSmkVZfDGkEruhM+1mu4YEj18h02cioYZc4wb6k5S29+n7n1MHEGxTtz /B6Agk7Ei2LWLYgHIsEqRZ0I0/i+UlClQw0wkO0oI8rP89/Onftr/pAJOHMrgvUIbg4Y1DOR+Rp nIYK2KpIgmHuRhpVaOjdx8O+W4DyfsFMHmc3G4Tsm5olfG6xrlQxM7z2Gx2DM1BuRfeeHKaII= X-Google-Smtp-Source: AGHT+IH5MBnZ80QmDB+DacHXeqciP6aVknXwO7Vp5gJAZ7tuJsdeR/PJTAmpN5vE0+Q4zrby9KtH2xbuWmv7LYBX9BY= X-Received: by 2002:a05:6820:2292:b0:604:359:e0b0 with SMTP id 006d021491bc7-6040359e36dmr849445eaf.7.1743599551107; Wed, 02 Apr 2025 06:12:31 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Ron Johnson Date: Wed, 2 Apr 2025 09:12:20 -0400 X-Gm-Features: AQ5f1JolVQqMOI_7HlwXs2-gB6qlWO_jn4fY0BSuF2daXfp4q0k5bs8IjCMDRoQ Message-ID: Subject: Re: psql formatting question To: Pgsql-admin Content-Type: multipart/alternative; boundary="000000000000dfd8ed0631cb6797" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000dfd8ed0631cb6797 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Wed, Apr 2, 2025 at 12:56=E2=80=AFAM Edwin UY wrote= : > > Hi, > > Apologies to start with as this is run against a RDS database. > TBH, I wish I have non-RDS database to learn PostgreSQL more. I do am > looking for a remote job :-) > > Anyway, on to the question. > I am pretty sure the answer will be a NO but maybe it isn't. > 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? > > =3D> select name, setting from pg_settings where name like '%extensions%'= ; > 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, fuzzystrmatch, h3, h3_postgis, hll, hstore, = hs > tore_plperl, hypopg, insert_username, intagg, intarray, ip4r, isn, > jsonb_plperl, lo, log_fdw, ltree, moddatetime, mysql_fdw, old_snapshot, > oracle_fdw, > orafce, pageinspect, pg_bigm, pg_buffercache, pg_cron, pg_freespacemap, > pg_hint_plan, pg_partman, pg_prewarm, pg_proctab, pg_repack, pg_similarit= y, > p > g_stat_statements, pg_tle, pg_transport, pg_trgm, pg_visibility, pgactive= , > pgaudit, pgcrypto, pglogical, pgrouting, pgrowlocks, pgstattuple, pgtap, = pl > coffee, plls, plperl, plpgsql, plprofiler, plrust, pltcl, plv8, postgis, > postgis_raster, postgis_tiger_geocoder, postgis_topology, postgres_fdw, > prefi > x, rdkit, rds_tools, refint, seg, sslinfo, tablefunc, tcn, tds_fdw, > test_parser, tsm_system_rows, tsm_system_time, unaccent, uuid-ossp, vecto= r > (3 rows) > > 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, fuzzystrmatch, > h3, h3_postgis, > hll, hstore, hstore_plperl, hypopg, > insert_username, intagg, intarray, ip4r, isn, jsonb_plperl, lo, log_fdw, > ltree, moddatetime, > -------- > -------- > Another formatting possibility: \pset expanded --=20 Death to , and butter sauce. Don't boil me, I'm still alive. lobster! --000000000000dfd8ed0631cb6797 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
On Wed, Apr 2, 2025 at 12:56=E2=80=AFAM E= dwin UY <edwin.uy@gmail.com>= ; wrote:

Hi,

Apologies to start with= as this is run against a RDS database.=C2=A0
TBH, I wish I have non-RDS database to learn Pos= tgreSQL more. I do am looking for a remote job :-)

Anyway, on to the question.
I am pretty sure the answer w= ill be a NO but maybe it isn't.
Are there any psql settings that I can set to format t= he output for below so that the output of settings is wrapped sort of?
=

=3D> select name, setting from = pg_settings where name like '%extensions%' ;
=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 =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 =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=A0setting



----------------------------------+-----------= ---------------------------------------------------------------------------= -----------------------------
------------------------------------------= ---------------------------------------------------------------------------= ---------------------------------
--------------------------------------= ---------------------------------------------------------------------------= -------------------------------------
----------------------------------= ---------------------------------------------------------------------------= -----------------------------------------
------------------------------= ---------------------------------------------------------------------------= ---------------------------------------------
--------------------------= ---------------------------------------------------------------------------= -------------------------------------------------
----------------------= ---------------------------------------------------------------------------= ----------------------------------------------
=C2=A0rds.allowed_delegat= ed_extensions |
=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
_plpe= rl, btree_gin, btree_gist, citext, cube, dblink, dict_int, dict_xsyn, earth= distance, flow_control, fuzzystrmatch, h3, h3_postgis, hll, hstore, hs
t= ore_plperl, hypopg, insert_username, intagg, intarray, ip4r, isn, jsonb_plp= erl, lo, log_fdw, ltree, moddatetime, mysql_fdw, old_snapshot, oracle_fdw,<= br>=C2=A0orafce, pageinspect, pg_bigm, pg_buffercache, pg_cron, pg_freespac= emap, pg_hint_plan, pg_partman, pg_prewarm, pg_proctab, pg_repack, pg_simil= arity, p
g_stat_statements, pg_tle, pg_transport, pg_trgm, pg_visibility= , pgactive, pgaudit, pgcrypto, pglogical, pgrouting, pgrowlocks, pgstattupl= e, pgtap, pl
coffee, plls, plperl, plpgsql, plprofiler, plrust, pltcl, p= lv8, postgis, postgis_raster, postgis_tiger_geocoder, postgis_topology, pos= tgres_fdw, prefi
x, rdkit, rds_tools, refint, seg, sslinfo, tablefunc, t= cn, tds_fdw, test_parser, tsm_system_rows, tsm_system_time, unaccent, uuid-= ossp, vector
(3 rows)<= /span>

Hoping 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 setting
=C2=A0rds.allowed_delegat= ed_extensions |
=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, =
=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_gi= st, citext, cube, dblink, dict_int, dict_xsyn, earthdistance, flow_control,= fuzzystrmatch, h3, h3_postgis,
=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=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 hll, hstore, hstore_plperl, hypopg, insert_username, = intagg, intarray, ip4r, isn, jsonb_plperl, lo, log_fdw, ltree, moddatetime,=
--------
--------

Another formatting possibility:
\pset expanded

--
Death to <Redacted>, and butter sauce.
Don't boil me, I'= m still alive.
<Redacted> lobster!
--000000000000dfd8ed0631cb6797--