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 1tzq94-007OcF-Cn for pgsql-admin@arkaria.postgresql.org; Wed, 02 Apr 2025 04:56:10 +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 1tzq92-009krL-KK for pgsql-admin@arkaria.postgresql.org; Wed, 02 Apr 2025 04:56:08 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tzq92-009kpv-6n for pgsql-admin@lists.postgresql.org; Wed, 02 Apr 2025 04:56:08 +0000 Received: from mail-pj1-x1036.google.com ([2607:f8b0:4864:20::1036]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1tzq90-002tqZ-09 for pgsql-admin@lists.postgresql.org; Wed, 02 Apr 2025 04:56:07 +0000 Received: by mail-pj1-x1036.google.com with SMTP id 98e67ed59e1d1-2ff69365e1dso8485922a91.3 for ; Tue, 01 Apr 2025 21:56:05 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1743569763; x=1744174563; darn=lists.postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=+QbVWosajh0QsgyMMKuiS6NSg8SrEDa2zsEbrupU7nQ=; b=QoIcXVTF/EDZGBvcmkHbncZ5X7ZukfP7zb8S4UrRUstP+qfnPsmJUcTCEXnDAFIpue eCd8+DqCBlsEOVOnKcMB/Xu3auzpQK9AvrbrsxnwuvsjILCmATWlRSU+pEftRvgPfjhJ K26RfmgCHlIbZZBBq/Fm1amrCDpp1cSDE9Vtjeds/yahNIXSvQjKtkHfQKVFhntKfmEB f2rZf8/a46+YV8oNYN7yJhz0FtswXyo8tMbG+rRkEx+Kt89s2vMBqfabWycuoMDEqQdC U7njZfxlwM2VlxZFrsiZPGohThjUVA1ZExd2+WvEHXuCpwZId3a02WE2v6orfLIEKz16 9hxA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1743569763; x=1744174563; h=to:subject:message-id:date:from:mime-version:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=+QbVWosajh0QsgyMMKuiS6NSg8SrEDa2zsEbrupU7nQ=; b=QUJUZ10g3jcBtrl8WPhmVfC+i7Oaw49Fge/wkZvlkiuipQQvj14vfjlpQRrGD3dkqg cgv+y1B1OlX1PJB2QLNoe1mR8LzEmQAtHw2nLQZMLa3ORS3wM7ST/dMWrqcu8Tz2/2ub 6VGmcZhjM+ktbsIxTLb3I1Pz8M16Eow3kg56NZd7TsZFerZhiU9caMAh3Y7nUb6D+3U3 xxMJxJok93EtAUr+iRN6+rI10tdIQYi0F8VXbZuk1F39MLiEM1TdqdJKShUT/kORsP3/ fMIWn3S4naEoyRN+B4E/cE4h697fHaneCOqerK/z8KrIyINwzFKHkrBUKO64k1W8Dd7Z QcVg== X-Gm-Message-State: AOJu0YyXXy6hzHvbX4rhLXh7am9ZX+omAeDrLpoD3HsxK14I+y5AVf3X mlw2fXzrd5Az6mEG7EBkIOYk/b8vIEPEIs1mSolDzqpIaVlVn63lhJdNRD/jUYXtf+xO7cBfQ/B j3qJ9FBYGT5/3xuFzuBn58eQUxx6ZIbxqAKYrMw== X-Gm-Gg: ASbGnctlU8jsVUKdq7Cx+HD+RBNRb/OQQLNzFNmVzgvq+ij7qg9lCrxH8xQZ6yJgxp7 eO72M9ugHrx7gRP4GoAL6X/ERp7X/RcTyX0Qk7mh8VPJkcAx1duVAvNVBL2p99d2DcnsOS1Xfmx oHSuF7bfsOP67n5k/SGvNQswU79Q== X-Google-Smtp-Source: AGHT+IGliXDKJ5jzdBuDY/X6lWX03tQxNglfjfZYznPxCdG42F2RvS3Zt6ZuWyjUMz+eD/XcIQjwqlXTlMCdJMmOMG0= X-Received: by 2002:a17:90b:4c12:b0:305:2d27:7cb0 with SMTP id 98e67ed59e1d1-305320b95e3mr20636829a91.21.1743569763215; Tue, 01 Apr 2025 21:56:03 -0700 (PDT) MIME-Version: 1.0 From: Edwin UY Date: Wed, 2 Apr 2025 17:55:26 +1300 X-Gm-Features: AQ5f1JqatFgC9dGE5cE0__NPma6Izvwe4FdSkyu8fLc4Bhn7agIXpCFX36Aj8yw Message-ID: Subject: psql formatting question To: Pgsql-admin Content-Type: multipart/alternative; boundary="00000000000060b4390631c478c4" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --00000000000060b4390631c478c4 Content-Type: text/plain; charset="UTF-8" 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? => 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_similarity, 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, vector (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, -------- -------- --00000000000060b4390631c478c4 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable

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 PostgreSQL more. I do am looking for a rem= ote 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,=
--------
--------




--00000000000060b4390631c478c4--