One thing that is different about Postgres is that it uses a lot of
"meta-commands".
https://www.postgresql.org/docs/current/app-psql.html
An important one is "\q", which exits you from the database. Typing
"quit" or "exit" won't get you out of the session.
= Eric MacAdie
On Mon, Mar 30, 2020 at 11:16 PM Turritopsis Dohrnii Teo En Ming
<ceo@teo-en-ming.com> wrote:
>
> On 2020-03-30 21:26, Wim Bertels wrote:
> > Turritopsis Dohrnii Teo En Ming schreef op ma 30-03-2020 om 20:49
> > [+0800]:
> >> Good evening from Singapore,
> >>
> >> Is PostgreSQL SQL database command syntax similar to MySQL/MariaDB?
> >
> > Unfortunately mysql/mariadb syntax differs in general more than others
> > dbms from the iso/ansi sql standard.
> >
> >>
> >> Because I have never used PostgreSQL before.
> >
> > So you might have to adapt a bit when leaving mysql/mariadb for another
> > dbms. To start development you should be ok,
> > if you want to migrate data, you might want to use a migration tool (or
> > fdw) (instead of dumping mysql syntax into postgresql)
>
> I have had more exposure to MySQL/MariaDB in the past.
>
>
> >
> >>
> >> I am looking forward to hearing from you soon.
> >>
> >> Thank you.
> >>
> >>
> >>
> >>
> >>
> >>
> >>
>
> >>
> >>
> > --
> > mvg,
> > Wim Bertels
> > --
> > Lector
> > UC Leuven-Limburg
> > --
> > For years a secret shame destroyed my peace--
> > I'd not read Eliot, Auden or MacNiece.
> > But now I think a thought that brings me hope:
> > Neither had Chaucer, Shakespeare, Milton, Pope.
> > -- Justin Richardson.
>
>
> -----BEGIN EMAIL SIGNATURE-----
>
> The Gospel for all Targeted Individuals (TIs):
>
> [The New York Times] Microwave Weapons Are Prime Suspect in Ills of
> U.S. Embassy Workers
>
> Link:
> https://www.nytimes.com/2018/09/01/science/sonic-attack-cuba-microwave.html
>
> ********************************************************************************************
>
> Singaporean Mr. Turritopsis Dohrnii Teo En Ming's Academic
> Qualifications as at 14 Feb 2019 and refugee seeking attempts at the
> United Nations Refugee Agency Bangkok (21 Mar 2017), in Taiwan (5 Aug
> 2019) and Australia (25 Dec 2019 to 9 Jan 2020):
>
> [1] https://tdtemcerts.wordpress.com/
>
> [2] https://tdtemcerts.blogspot.sg/
>
> [3] https://www.scribd.com/user/270125049/Teo-En-Ming
>
> -----END EMAIL SIGNATURE-----
>
>