Re: Changing Datatypes - Mailing list pgsql-general

From Frank Bax
Subject Re: Changing Datatypes
Date
Msg-id 3.0.6.32.20001224160014.00b422e0@pop6.sympatico.ca
Whole thread Raw
In response to Changing Datatypes  ("Aaron Rouse" <pgsql@happyhacker.com>)
List pgsql-general
At 11:38 PM 12/23/00 -0600, Aaron Rouse wrote:
>I recently migrating a Access 97 database into my PGSQL 7.02 database and
>notice that some of my datatypes need to be changed.  What would be the
>command for changing datatypes on columns?

http://www.postgresql.org/devel-corner/docs/user/functions-formatting.htm

>I also had table names with
>mixed case in their names, is there a way to make PGSQL not be case
>sensitive on table/column names?

Remove the quotes around table/field names when creating them.

pgsql-general by date:

Previous
From: "Aaron Rouse"
Date:
Subject: Changing Datatypes
Next
From: GH
Date:
Subject: group by and order by question