Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

BUG #2648: I can not create table name with capital and small characters



The following bug has been logged online:

Bug reference:      2648
Logged by:          Asaf Avraham
Email address:      asaf(dot)avraham(at)gmail(dot)com
PostgreSQL version: 8.1.4.2
Operating system:   win
Description:        I can not create table name with capital and small
characters
Details: 

I have table that contain name with capital and small characters (ex.
tblEmp). In the columns is the same (ex. EmpID).  

In Creating table postgres add inverted commas on the name

When I'm running any query on this table i get:
1. select * from tblEmp
   Get: ERROR:  relation "tblemp" does not exist
2. select * from "tblEmp"
   Get: Resulted

Thanks



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group