public inbox for [email protected]  

help / color / mirror / Atom feed

From: Adrian Klaver <[email protected]>
To: COURTAULT Francois <[email protected]>
To: [email protected] <[email protected]>
Subject: Re: Redo CREATE DATABASE
Date: Mon, 17 Nov 2025 07:52:14 -0800
Message-ID: <[email protected]> (raw)
In-Reply-To: <MR1PPF8993717D761DDD789CE20C6D9203B9DC9A@MR1PPF8993717D7.FRAP264.PROD.OUTLOOK.COM>
References: <MR1PPF8993717D761DDD789CE20C6D9203B9DC9A@MR1PPF8993717D7.FRAP264.PROD.OUTLOOK.COM>

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]

view thread (5+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: Redo CREATE DATABASE
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox