Re: Is PostgreSQL SQL Database Command Syntax Similar toMySQL/MariaDB?

Поиск
Список
Период
Сортировка
От Wim Bertels
Тема Re: Is PostgreSQL SQL Database Command Syntax Similar toMySQL/MariaDB?
Дата
Msg-id d1903dcbe4ce4533b95325b4cb29a49cfe51dfff.camel@ucll.be
обсуждение исходный текст
Ответ на Is PostgreSQL SQL Database Command Syntax Similar to MySQL/MariaDB?  (Turritopsis Dohrnii Teo En Ming <ceo@teo-en-ming.com>)
Ответы Re: Is PostgreSQL SQL Database Command Syntax Similar toMySQL/MariaDB?  (Turritopsis Dohrnii Teo En Ming <ceo@teo-en-ming.com>)
Список pgsql-general
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.




В списке pgsql-general по дате отправления:

Предыдущее
От: Pavel Stehule
Дата:
Сообщение: Re: Is PostgreSQL SQL Database Command Syntax Similar to MySQL/MariaDB?
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Uploading existing shapefile from geoserver to postgresql