agora inbox for pgsql-docs@postgresql.orghelp / color / mirror / Atom feed
creating a database 3+ messages / 3 participants [nested] [flat]
* creating a database @ 2025-02-02 09:25 PG Doc comments form <noreply@postgresql.org> 2025-02-02 15:35 ` Re: creating a database David G. Johnston <david.g.johnston@gmail.com> 0 siblings, 1 reply; 3+ messages in thread From: PG Doc comments form @ 2025-02-02 09:25 UTC (permalink / raw) To: pgsql-docs@lists.postgresql.org; +Cc: raf.meeusen@gmail.com The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/tutorial-createdb.html Description: Dear, I was reading intro to setup of postgresql, and looking at https://www.postgresql.org/docs/current/tutorial-createdb.html#TUTORIAL-CREATEDB Regarding the sentence "To create a new database, in this example named mydb, you use the following command:" I guess this is on the server side, in a Linux shell or similar? But it is not explicitly stated, and this section comes right after explanation of client-server. I think this should be clarified in the text. And what also could be clarified: can a database only be created on the server side? Or is there also a client (SQL) command to create a new database on the server? best regards, Raf ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: creating a database 2025-02-02 09:25 creating a database PG Doc comments form <noreply@postgresql.org> @ 2025-02-02 15:35 ` David G. Johnston <david.g.johnston@gmail.com> 2025-02-02 15:53 ` Re: creating a database Tom Lane <tgl@sss.pgh.pa.us> 0 siblings, 1 reply; 3+ messages in thread From: David G. Johnston @ 2025-02-02 15:35 UTC (permalink / raw) To: raf.meeusen@gmail.com <raf.meeusen@gmail.com>; pgsql-docs@lists.postgresql.org <pgsql-docs@lists.postgresql.org> On Sunday, February 2, 2025, PG Doc comments form <noreply@postgresql.org> wrote: > > I guess this is on the server side, in a Linux shell or similar? > > I think this should be clarified in the text. We haven’t even mentioned psql yet, aside from the conventions page where we cover $ means a shell prompt. > And what also could be clarified: can a database only be created on the > server side? > Or is there also a client (SQL) command to create a new database on the > server? The description of createdb explains it is a wrapper for the “create database” sql command. If I am to add anything it would probably be on the “architecture fundamentals” page. The points brought up are not specific to createdb and probably should be explained up-front as to the fact we have wrapped a number of SQL utility commands for the DBA as executable programs. David J. ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: creating a database 2025-02-02 09:25 creating a database PG Doc comments form <noreply@postgresql.org> 2025-02-02 15:35 ` Re: creating a database David G. Johnston <david.g.johnston@gmail.com> @ 2025-02-02 15:53 ` Tom Lane <tgl@sss.pgh.pa.us> 0 siblings, 0 replies; 3+ messages in thread From: Tom Lane @ 2025-02-02 15:53 UTC (permalink / raw) To: David G. Johnston <david.g.johnston@gmail.com>; +Cc: raf.meeusen@gmail.com <raf.meeusen@gmail.com>; pgsql-docs@lists.postgresql.org <pgsql-docs@lists.postgresql.org> "David G. Johnston" <david.g.johnston@gmail.com> writes: > On Sunday, February 2, 2025, PG Doc comments form <noreply@postgresql.org> > wrote: >> And what also could be clarified: can a database only be created on the >> server side? >> Or is there also a client (SQL) command to create a new database on the >> server? > The description of createdb explains it is a wrapper for the “create > database” sql command. Yeah. What this page is really meant to do is help you get past typical problems in accessing an installation you've just set up. We mustn't load it down with answers to every question a novice could have, especially not questions that are answered on adjacent or linked pages. If we were to extend it at all, I'd think about expanding its charter to include "help you get past typical problems in accessing an installation on another machine". This'd involve mentioning the -h and -p switches, probably. But I'm not sure if that would be a net benefit or just confuse some users more than it helps others. Another thought is that the first para on the next page, which mentions alternatives such as pgAdmin, maybe should be moved here with some suitable alterations (or added to the end of Architectural Fundamentals, perhaps). Both of these pages are oriented towards "access Postgres from a terminal command line", which I concede is probably a minority thing anymore. regards, tom lane ^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2025-02-02 15:53 UTC | newest] Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2025-02-02 09:25 creating a database PG Doc comments form <noreply@postgresql.org> 2025-02-02 15:35 ` David G. Johnston <david.g.johnston@gmail.com> 2025-02-02 15:53 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox