Changing Datatypes

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.