On Mon, 28 May 2001, Pruner Jan wrote:
> Hi, Pieter,
> there is no problem with ODBC, but
> you have to move your database architecture to PostgreSQL.
> There are some problems with the the lack of SQL compatibleness between MS &
> PG (of course - no standard).
>
> MS use getdate() to get current_timestamp etc.
>
> I stopped porting because I have table 'name' on MS, but on PG is it
> impossible.
Hi,
The reason is PG's built in data type 'name'. As your
databases superuser you may drop this data type, then you can
create tables named 'name' :-)
If you don't need type 'name' do
DROP TYPE name;
Then you can do
CREATE table name (...);
> ...
--
Dipl-Ing. Martin Jacobs * Windsbach * Germany
Registered Linux User #87175, http://counter.li.org/