Postgres Pro
Downloads
Home   >   mailing lists

Thread: Data layer migration from MSSQL

Data layer migration from MSSQL

From
"Sebastian Rychter"
Date:
<div class="Section1"><p class="MsoNormal"><span lang="EN-US">Hi, I’m working on migrating a data layer from MS SQL
Serverto PostgreSQL 8.2 and found that some reserved words should only be written between quotes and thus are case
sensitive(actually only happened with a table field named “order”). Is there any way to bypass this  case sensitivity
orat least determine that I am going to use certain reserved words as table fields (or any other possible solutions)
?</span><pclass="MsoNormal"><span lang="EN-US"> </span><p class="MsoNormal"><span lang="EN-US">Thanks,</span><p
class="MsoNormal"><spanlang="EN-US"> </span><p class="MsoNormal"><span lang="EN-US">Sebastian</span></div>

Re: Data layer migration from MSSQL

From
"Medi Montaseri"
Date:
I think the grammer should help the parser to determine what you mean when the token ORDER is seen.

for example in a select statement...

Syntax:
SELECT expression [, ...]
    ...
    [ FROM from_item [, ...] ]
    [ WHERE condition ]
    ...
    [ ORDER BY expression [ ASC | DESC | USING operator ]

keywords (or reserved words) should not be placed in quotes because the parser relies on them to steer ...

Cheers
Medi

On Thu, Feb 21, 2008 at 9:47 AM, Sebastian Rychter <srychter@anvet.com.ar> wrote:

Hi, I'm working on migrating a data layer from MS SQL Server to PostgreSQL 8.2 and found that some reserved words should only be written between quotes and thus are case sensitive (actually only happened with a table field named "order"). Is there any way to bypass this  case sensitivity or at least determine that I am going to use certain reserved words as table fields (or any other possible solutions) ?

 

Thanks,

 

Sebastian


Re: Data layer migration from MSSQL

From
"Sebastian Rychter"
Date:

Sorry,  I think it was misunderstood. I meant that I used the keyword “Order” as a table property, not as part as the statement

In MS SQL I use [Order] and then just query :

 

Select [Table1].[Order] from [Table1]

 

Or

 

Select [Table1].[order] from [Table1]

 

In Postgresql I can’t do : create table Table1 (order varchar(10))  -- because “order” is a keyword

I have to do it like : create Table1 (“Order” varchar(10))

And then always do the query like : Select “Order” from Table1

which is different from

                                                                       Select “order” from Table1

 

Thanks again.

 

De: Medi Montaseri [mailto:montaseri@gmail.com]
Enviado el: jueves, 21 de febrero de 2008 16:43
Para: Sebastian Rychter
CC: pgsql-sql@postgresql.org
Asunto: Re: [SQL] Data layer migration from MSSQL

 

I think the grammer should help the parser to determine what you mean when the token ORDER is seen.

for example in a select statement...

Syntax:
SELECT expression [, ...]
    ...
    [ FROM from_item [, ...] ]
    [ WHERE condition ]
    ...
    [ ORDER BY expression [ ASC | DESC | USING operator ]

keywords (or reserved words) should not be placed in quotes because the parser relies on them to steer ...

Cheers
Medi

On Thu, Feb 21, 2008 at 9:47 AM, Sebastian Rychter <srychter@anvet.com.ar> wrote:

Hi, I'm working on migrating a data layer from MS SQL Server to PostgreSQL 8.2 and found that some reserved words should only be written between quotes and thus are case sensitive (actually only happened with a table field named "order"). Is there any way to bypass this  case sensitivity or at least determine that I am going to use certain reserved words as table fields (or any other possible solutions) ?

 

Thanks,

 

Sebastian