Re: Porting from MySQL. - Mailing list pgsql-ports

From Marko Kreen
Subject Re: Porting from MySQL.
Date
Msg-id 20011004212653.A8808@l-t.ee
Whole thread Raw
In response to Porting from MySQL.  (Danny Appaiah <danny@indvalley.com>)
List pgsql-ports
On Thu, Oct 04, 2001 at 04:10:26PM +0530, Danny Appaiah wrote:
> My Table Name: NetworkName
> Column Name1 : NetCode
> Column Name2 : NetworkName

By default PostgreSQL turns all table/column names to lowercase,
unless you tell it not to:

marko=# create table tEst (vAl text);
CREATE
marko=# create table "tEst2" ("vAl" text);
CREATE
marko=# \d test
        Table "test"
 Attribute | Type | Modifier
-----------+------+----------
 val       | text |

marko=# \d "tEst2"
        Table "tEst2"
 Attribute | Type | Modifier
-----------+------+----------
 vAl       | text |


--
marko


pgsql-ports by date:

Previous
From: "Scott W. Hill"
Date:
Subject: Re: postgres on MacOS X 10.1
Next
From: Tiaan Wessels
Date:
Subject: failed to compile on irix6.5 with gcc