Ispirer Ispirer
 

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

sqlways:postgresql:identifiers [September 01, 2009, 10:52:20 AM]
leonov
sqlways:postgresql:identifiers [May 07, 2018, 03:15:32 PM] (current)
Line 1: Line 1:
 \\ \\
-[[http://www.ispirer.com/products/postgresql-migration|SQLWays Product Page - Migration to PostgreSQL]] +[[http://www.ispirer.com|Ispirer Home Page]] 
-[[http://www.ispirer.com/download|Free Evaluation]]+[[http://www.ispirer.com/products/postgresql-migration|Ispirer SQLWays Product Page - Migration to PostgreSQL]] 
 +[[http://www.ispirer.com/?click=RequestSQLWays&from=IspirerWIKI|Request SQLWays]]
  
 ====== PostgreSQL Identifiers ====== ====== PostgreSQL Identifiers ======
Line 24: Line 25:
 | **MySQL** | [[sqlways:mysql/identifiers|MySQL Identifiers ]] | Allowed: digit \\ Not allowed: _ | No differences | 64 |  | **MySQL** | [[sqlways:mysql/identifiers|MySQL Identifiers ]] | Allowed: digit \\ Not allowed: _ | No differences | 64 | 
 | **Sybase ASE** | [[sqlways:sybase/identifiers|Sybase ASE Identifiers ]] | Allowed: @ and # | Allowed: @ and # | 255 |  | **Sybase ASE** | [[sqlways:sybase/identifiers|Sybase ASE Identifiers ]] | Allowed: @ and # | Allowed: @ and # | 255 | 
 +| **Sybase ASA** | [[sqlways:sybase/asa-identifiers|Sybase ASA Identifiers ]] | Allowed: $, @ and # | Allowed: @ and # | 128 |  
 +| **Informix** | [[sqlways:informix/identifiers|Informix Identifiers ]] | No differences | No differences | 128 |  
 +| **Teradata** | [[sqlways:teradata/identifiers|Teradata Identifiers ]] | Allowed: $ and #  | Allowed: # | 30 |  
 +| **HP Neoview** | [[sqlways:neoview/identifiers|HP Neoview Identifiers ]] | Not allowed: _ | Not allowed: $ | 128 |  
 +| **Interbase/Firebird** | [[sqlways:interbase-firebird/identifiers|Interbase/Firebird Identifiers ]] | Not allowed: _  | No differences | 67 | 
  
 ===== Quoted or Delimited Identifiers ===== ===== Quoted or Delimited Identifiers =====
Line 40: Line 45:
 | **Oracle** | [[sqlways:oracle/identifiers#quoted_or_delimited_identifiers|Oracle Quoted Identifiers ]] | "" | Any except quotes | Case sensitive |  | **Oracle** | [[sqlways:oracle/identifiers#quoted_or_delimited_identifiers|Oracle Quoted Identifiers ]] | "" | Any except quotes | Case sensitive | 
 | **SQL Server** | [[sqlways:sql-server/identifiers#quoted_or_delimited_identifiers|SQL Server Quoted Identifiers ]] | [] and "" | Any except quotes | Case insensitive | | **SQL Server** | [[sqlways:sql-server/identifiers#quoted_or_delimited_identifiers|SQL Server Quoted Identifiers ]] | [] and "" | Any except quotes | Case insensitive |
-| **IBM DB2** | [[sqlways:db2/identifiers|IBM DB2 Identifiers ]] | "" | Any including quotes | Case sensitive |  +| **IBM DB2** | [[sqlways:db2/identifiers#quoted_or_delimited_identifiers|IBM DB2 Quoted Identifiers ]] | "" | Any including quotes | Case sensitive |  
-| **MySQL** | [[sqlways:mysql/identifiers|MySQL Identifiers ]] | `` and "" | Any except quotes | Case sensitive |  +| **MySQL** | [[sqlways:mysql/identifiers#quoted_or_delimited_identifiers|MySQL Quoted Identifiers ]] | `` and "" | Any except quotes | Case sensitive |  
-| **Sybase ASE** | [[sqlways:sybase/identifiers#quoted_or_delimited_identifiers|Sybase ASE Quoted Identifiers ]] | [] and "" | Any except quotes | Case insensitive | +| **Sybase ASE** | [[sqlways:sybase/identifiers#quoted_or_delimited_identifiers|Sybase ASE Quoted Identifiers ]] | [] and "" | Any except pound sign (#) as the first character | Case insensitive |  
 +| **Sybase ASA** | [[sqlways:sybase/asa-identifiers#quoted_or_delimited_identifiers|Sybase ASA Quoted Identifiers ]] | [] and "" | Any | Case insensitive |  
 +| **Informix** | [[sqlways:informix/identifiers#quoted_or_delimited_identifiers|Informix Quoted Identifiers ]] | "" | Any including quotes | Case sensitive |  
 +| **Teradata** | [[sqlways:teradata/identifiers#quoted_or_delimited_identifiers|Teradata Quoted Identifiers ]] | "" | Any including quotes | Case insensitive |  
 +| **HP Neoview** | [[sqlways:neoview/identifiers#quoted_or_delimited_identifiers|HP Neoview Quoted Identifiers ]] | "" | Any except at sign (@), forward slash (/), \\ circumflex character (<html>^</html>) as the first character \\ and space(s) as the last character(s) | Case sensitive |  
 +| **Interbase/Firebird** | [[sqlways:interbase-firebird/identifiers#quoted_or_delimited_identifiers|Interbase/Firebird Quoted Identifiers ]] | "" | Any character except space(s) as the last character(s)  | Case sensitive 
  
 \\ \\
-[[http://www.ispirer.com/products/postgresql-migration|SQLWays Product Page - Migration to PostgreSQL]] +[[http://www.ispirer.com|Ispirer Home Page]] 
-[[http://www.ispirer.com/download|Free Evaluation]]+[[http://www.ispirer.com/products/postgresql-migration|Ispirer SQLWays Product Page - Migration to PostgreSQL]] 
 +[[http://www.ispirer.com/?click=RequestSQLWays&from=IspirerWIKI|Request SQLWays]]
sqlways/postgresql/identifiers.1251802340.txt.gz · Last modified: May 07, 2018, 03:11:36 PM (external edit)
 
© 1999-2019, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement