On 11/17/25 01:59, COURTAULT Francois wrote:
THALES GROUP LIMITED DISTRIBUTION to email recipients
Hello everyone,
I am looking to an old document where we (I was not there at that time)
setup a database.
Unfortunately, I was not able to find the CREATE DATABASE instruction
used. It is not in any of our docs ☹
At https://www.postgresql.org/docs/17/sql-createdatabase.html <https://
www.postgresql.org/docs/17/sql-createdatabase.html> we can see that a
lot of options are available.
Do you know if it is possible to retrieve the options we have set when
we created the database ?
Assuming the database is still in the cluster.
In psql have you tried:
\l+ <the_db_name>
Also
select * from pg_database where datname = <the_db_name>
They may not give you everything, but it will be a start.
Best Regards.
--
Adrian Klaver
[email protected]
