Re: Postgres for SQL Server users
| От | Ravi Krishna |
|---|---|
| Тема | Re: Postgres for SQL Server users |
| Дата | |
| Msg-id | 1632746998.783748.1557170911532@mail.yahoo.com обсуждение исходный текст |
| Ответ на | Postgres for SQL Server users (Igal Sapir <igal@lucee.org>) |
| Ответы |
Re: Postgres for SQL Server users
|
| Список | pgsql-general |
> I was wondering if anyone has any tips that are specific for SQL Server users? Best features? Known issues? Common
rebuttals?
Are you talking about SS to PG migration.
Generally SQLServer shops use SS specific functions and T-SQL heavily since they provide very good functionality.
For example:
1, convert function is used heavily in SQL to format various datetime formats.
2. SS does case insensitive searches. Converting it to PG involves modifying the SQL. Not an easy job to do.
3. SS has 3 part structures. DB.SCHEMA.TABLE which can be used in SQL. PG can go only up to 2 part SCHEMA.TABLE.
3 part is possible, but using FDW or other cumbersome mechanism.
В списке pgsql-general по дате отправления: