public inbox for [email protected]
help / color / mirror / Atom feedFrom: Adrian Klaver <[email protected]>
To: Kevin Stephenson <[email protected]>
To: Ron Johnson <[email protected]>
Cc: pgsql-generallists.postgresql.org <[email protected]>
Cc: [email protected] <[email protected]>
Subject: Re: Quesion about querying distributed databases
Date: Sat, 29 Mar 2025 08:09:11 -0700
Message-ID: <[email protected]> (raw)
In-Reply-To: <IA0PR19MB721709CBC9B6E0BDC33D52E88FA32@IA0PR19MB7217.namprd19.prod.outlook.com>
References: <CAEHBEOBuoMFWuhHM3L_Zr6o1enELju-Vns6Pknt4TT+6MFQOwQ@mail.gmail.com>
<[email protected]>
<CAEHBEOD969YrbPH_z9OEmThWx3-w4sMMaHLhZLOQwqCwE8Y58Q@mail.gmail.com>
<[email protected]>
<CAEHBEOBXzkGTqxQSYqmEFN5hbc=zsGWFpU9h8zf7AAPv4VdOWQ@mail.gmail.com>
<[email protected]>
<CAEHBEOBNoG8RkKuCcQQWkbYppMLMzA0MXq+s0kZ6wKWgD7+45Q@mail.gmail.com>
<[email protected]>
<CAEHBEODw8svX557pjB_EL-Os7KWtwi-9Uq=RuCkRKgHVZWw8Bw@mail.gmail.com>
<[email protected]>
<CAEHBEOCpxASoNn=u21kaqOn1A-4YPy_mVfgkEjT3wRT5G4ycbg@mail.gmail.com>
<CAKAnmmKiPkxVVTQ6-_MieuroWEnemJQEPLKsLjkdbbub--q2ng@mail.gmail.com>
<CA+FnnTxg+b2aiYQ92f5CFfhV9kg7YF3s26_dGJG-02ywAtz6sQ@mail.gmail.com>
<CANzqJaAmNL0_ky6EtXDJ4mXAiW=v1dYM==KkABoCLO=_7oXA2g@mail.gmail.com>
<IA0PR19MB721709CBC9B6E0BDC33D52E88FA32@IA0PR19MB7217.namprd19.prod.outlook.com>
On 3/29/25 02:15, Kevin Stephenson wrote:
> Bumping this old thread to clarify a few points.
>
> As an initial note on terminology, a "server" can be called a server, an
> instance, a server instance, or in PostgreSQL's (PG hereafter) case, a
> "DB Cluster." They all are used interchangeably in the wild to mean the
> same thing, with perhaps "server" being the most ambiguous. And that
> thing is a running process that is listening to (typically) a single
> port and handing connections off to individual threads or processes (or
> some other construct). The comments below use the word "instance" for
> consistency and brevity.
>
> MariaDB
> As mentioned by others, MariaDB (and MySQL proper, both hereafter
> referred to as MySQL) instances only support a single database. The
> CREATE DATABASE statement is a de facto synonym for CREATE SCHEMA (it is
> disappointing that MySQL and MariaDB docs still do not mention this
> significant fact). To disabuse those who believe MySQL support multiple
Actually they do:
https://dev.mysql.com/doc/refman/9.2/en/create-database.html
"CREATE DATABASE creates a database with the given name. To use this
statement, you need the CREATE privilege for the database. CREATE SCHEMA
is a synonym for CREATE DATABASE."
https://mariadb.com/kb/en/create-database/
"CREATE DATABASE creates a database with the given name. To use this
statement, you need the CREATE privilege for the database. CREATE SCHEMA
is a synonym for CREATE DATABASE."
They don't expound on what that means in real terms.
> databases, query any of the INFORMATION_SCHEMA tables and for all those
> that have the *_CATALOG column (CATALOG is a synonym for DATABASE),
> notice every row in every table that shows a catalog column, they all
> say "def", as in default. Further, the identifier used in CREATE
> DATABASE will show up in INFORMATION_SCHEMA tables in *_SCHEMA columns.
--
Adrian Klaver
[email protected]
view thread (19+ messages)
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], [email protected], [email protected], [email protected]
Subject: Re: Quesion about querying distributed databases
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