Re: Changing Datatypes

From: Frank Bax <fbax(at)sympatico(dot)ca>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Changing Datatypes
Date: 2000-12-24 21:00:14
Message-ID: 3.0.6.32.20001224160014.00b422e0@pop6.sympatico.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Emmanuel Charpentier,,, 2000-12-25 10:41:45 Re: group by and order by question
Previous Message GH 2000-12-24 18:53:04 group by and order by question