Thread: Changing Datatypes

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?  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?

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.