Thread: Is PostgreSQL SQL Database Command Syntax Similar to MySQL/MariaDB?

Good evening from Singapore,

Is PostgreSQL SQL database command syntax similar to MySQL/MariaDB?

Because I have never used PostgreSQL before.

I am looking forward to hearing from you soon.

Thank you.







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

On 2020-03-30 21:03, Pavel Stehule wrote:
> po 30. 3. 2020 v 14:49 odesílatel Turritopsis Dohrnii Teo En Ming
> <ceo@teo-en-ming.com> napsal:
> 
>> Good evening from Singapore,
>> 
>> Is PostgreSQL SQL database command syntax similar to MySQL/MariaDB?
>> 
>> Because I have never used PostgreSQL before.
>> 
>> I am looking forward to hearing from you soon.
> 
> Some database commands are same, or similar. Some are absolutely
> different. It depends


Noted with thanks.



> 
> Regards
> 
> Pavel
> 
>> Thank you.
>> 


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

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 am looking forward to hearing from you soon.
> 
> Thank you.
> 
> 
> 
> 
> 
> 
> 
> -----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://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.nytimes.com%2F2018%2F09%2F01%2Fscience%2Fsonic-attack-cuba-microwave.html&data=02%7C01%7Cwim.bertels%40ucll.be%7Cb58a22dd7cca44dbff4f08d7d4a8c9d5%7Ce638861b15d94de6a65db48789ae1f08%7C0%7C0%7C637211694717781909&sdata=jjYYIaR9%2BT%2Bn5ZnZ10asrNYy29%2FOH1diXRa%2Fz73%2FeCc%3D&reserved=0
> 
> *********************************************************************
> ***********************
> 
> 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://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Ftdtemcerts.wordpress.com%2F&data=02%7C01%7Cwim.bertels%40ucll.be%7Cb58a22dd7cca44dbff4f08d7d4a8c9d5%7Ce638861b15d94de6a65db48789ae1f08%7C0%7C0%7C637211694717781909&sdata=7y%2F8jlQS2YBeXw%2BZ6114Adl7Vsh73teL8PmNWZd%2Fc8s%3D&reserved=0
> 
> [2] 
>
https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Ftdtemcerts.blogspot.sg%2F&data=02%7C01%7Cwim.bertels%40ucll.be%7Cb58a22dd7cca44dbff4f08d7d4a8c9d5%7Ce638861b15d94de6a65db48789ae1f08%7C0%7C0%7C637211694717781909&sdata=Z70%2BW5Q7OUXswXw5j4Lt85W2DyLSycu8d4FCc1s8pq8%3D&reserved=0
> 
> [3] 
>
https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.scribd.com%2Fuser%2F270125049%2FTeo-En-Ming&data=02%7C01%7Cwim.bertels%40ucll.be%7Cb58a22dd7cca44dbff4f08d7d4a8c9d5%7Ce638861b15d94de6a65db48789ae1f08%7C0%7C0%7C637211694717781909&sdata=Ug%2BqnOPc5bB4g1LrECXLIz8EOUKlvdDXF10%2BcUTfxTI%3D&reserved=0
> 
> -----END EMAIL SIGNATURE-----
> 
> 
-- 
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.

From: Turritopsis Dohrnii Teo En Ming <ceo@teo-en-ming.com>

> Is PostgreSQL SQL database command syntax similar to MySQL/MariaDB?


If you stuck to "standard SQL" in Mysql, you'll generally be fine; the differences will be pretty minor. The further
youstrayed from the standard will cause you more work -- usually. That being said, moving for any DB to another will
alwayscause you to find DB-specific things. Of course, there are always a few things that can only be done with
DB-specificcode, so you'll be rewriting those parts with certainty (an example is the insert-or-update concept). 

[Side note: I forced myself to read a good part of the SQL standard some time back and was amazed by how many times the
phrase"implementation defined" was used, which helps to explain why all the DBs do some things so differently.] 

The admin commands are quite different as well, be prepared for that, but I can't think of anything that Mysql can do
thatPg can't as well. (Although it's been awhile since I had to use Mysql, so I may have forgotten something.) 

Last but not least, please remember that all of those "unusual" things you had to do to get Mysql to work, or work
aroundits bugs, won't be needed and will more than likely get in your way with Postgresql. I'm not saying the Pg is
perfect,but that Mysql's bugs and oddities don't apply to Pg. 

Good luck with your conversion and welcome to Pg!
Kevin
This e-mail transmission, and any documents, files or previous e-mail messages attached to it, may contain confidential
information.If you are not the intended recipient, or a person responsible for delivering it to the intended recipient,
youare hereby notified that any disclosure, distribution, review, copy or use of any of the information contained in or
attachedto this message is STRICTLY PROHIBITED. If you have received this transmission in error, please immediately
notifyus by reply e-mail, and destroy the original transmission and its attachments without reading them or saving them
todisk. Thank you. 

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

On 2020-03-31 06:30, Kevin Brannen wrote:
> From: Turritopsis Dohrnii Teo En Ming <ceo@teo-en-ming.com>
> 
>> Is PostgreSQL SQL database command syntax similar to MySQL/MariaDB?
> 
> 
> If you stuck to "standard SQL" in Mysql, you'll generally be fine; the
> differences will be pretty minor. The further you strayed from the
> standard will cause you more work -- usually. That being said, moving
> for any DB to another will always cause you to find DB-specific
> things. Of course, there are always a few things that can only be done
> with DB-specific code, so you'll be rewriting those parts with
> certainty (an example is the insert-or-update concept).
> 
> [Side note: I forced myself to read a good part of the SQL standard
> some time back and was amazed by how many times the phrase
> "implementation defined" was used, which helps to explain why all the
> DBs do some things so differently.]
> 
> The admin commands are quite different as well, be prepared for that,
> but I can't think of anything that Mysql can do that Pg can't as well.
> (Although it's been awhile since I had to use Mysql, so I may have
> forgotten something.)
> 
> Last but not least, please remember that all of those "unusual" things
> you had to do to get Mysql to work, or work around its bugs, won't be
> needed and will more than likely get in your way with Postgresql. I'm
> not saying the Pg is perfect, but that Mysql's bugs and oddities don't
> apply to Pg.
> 
> Good luck with your conversion and welcome to Pg!
> Kevin

Noted with thanks.








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

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

Eric MacAdie <emacadie@gmail.com> writes:
> 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.

Actually, since v11 that does work ... a concession we've made
to MySQL converts ;-)

            regards, tom lane

Does phpMyAdmin support PostgreSQL?



On 2020-03-31 20:15, Ben Madin wrote:
> and \q works in MySQL, so it may not be different anyway :)
> 
> On Tue, 31 Mar 2020 at 08:18, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> 
>> Eric MacAdie <emacadie@gmail.com> writes:
>>> 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.
>> 
>> Actually, since v11 that does work ... a concession we've made
>> to MySQL converts ;-)
>> 
>> regards, tom lane
> 
> --
> 
>  [1]
> 
> Dr Ben Madin
> BVMS MVPHMgmt PhD MANZCVS GAICD
> Managing Director
> 
> Mobile:
> +61 448 887 220 [2]
> 
> E-mail:
> ben@ausvet.com.au
> 
> Website:
> www.ausvet.com.au [1]
> Skype: benmadin
> 
> Address:
> 5 Shuffrey Street
> Fremantle, WA 6160
> Australia
> 
> Links:
> ------
> [1] https://www.ausvet.com.au/
> [2] tel:+61448887220


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

On 2020-04-01 01:30, Amitabh Kant wrote:
> On Tue, Mar 31, 2020 at 5:58 PM Turritopsis Dohrnii Teo En Ming
> <ceo@teo-en-ming.com> wrote:
> 
>> Does phpMyAdmin support PostgreSQL?
>> 
>> On 2020-03-31 20:15, Ben Madin wrote:
>>> and \q works in MySQL, so it may not be different anyway :)
>>> 
>>> On Tue, 31 Mar 2020 at 08:18, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>>> 
>>>> Eric MacAdie <emacadie@gmail.com> writes:
>>>>> 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.
>>>> 
>>>> Actually, since v11 that does work ... a concession we've made
>>>> to MySQL converts ;-)
>>>> 
>>>> regards, tom lane
>>> 
>>> --
>>> 
>>> [1]
>>> 
>>> Dr Ben Madin
>>> BVMS MVPHMgmt PhD MANZCVS GAICD
>>> Managing Director
>>> 
>>> Mobile:
>>> +61 448 887 220 [2]
>>> 
>>> E-mail:
>>> ben@ausvet.com.au
>>> 
>>> Website:
>>> www.ausvet.com.au [1] [1]
>>> Skype: benmadin
>>> 
>>> Address:
>>> 5 Shuffrey Street
>>> Fremantle, WA 6160
>>> Australia
>>> 
>>> Links:
>>> ------
>>> [1] https://www.ausvet.com.au/
>>> [2] tel:+61448887220
>> 

> 
> If you are looking something similar, the closest that you can come is
> phpPgAdmin . Otherwise there is pgAdmin 4
> 

Noted with thanks.






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