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@xxxxxxxxxxxxxxx> 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----- > >
