Re: Porting from MySQL.

From: Marko Kreen <marko(at)l-t(dot)ee>
To: Danny Appaiah <danny(at)indvalley(dot)com>
Cc: pgsql-ports(at)postgresql(dot)org
Subject: Re: Porting from MySQL.
Date: 2001-10-04 19:26:53
Message-ID: 20011004212653.A8808@l-t.ee
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-ports by date

  From Date Subject
Next Message Tiaan Wessels 2001-10-05 07:17:15 failed to compile on irix6.5 with gcc
Previous Message Scott W. Hill 2001-10-04 18:40:54 Re: postgres on MacOS X 10.1