Skip site navigation (1) Skip section navigation (2)

Re: problem migratin from ms sql

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Bruno Depero <bruno(dot)depero(at)digicar(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: problem migratin from ms sql
Date: 2005-04-23 15:27:57
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
On Tue, Apr 19, 2005 at 17:35:05 +0200,
  Bruno Depero <bruno(dot)depero(at)digicar(dot)com> wrote:
> I wish to migrate from ms sql server to postgresql... an application 
> (windows executable) not developed by me then no sources. We buyed for a 
> lot of money so we must run it on windows clients.
> All works greatly, and with more performance too, from php I can do few 
> scripts without any problem.
> But there is a problem: for some reports this application create a 
> temporary table... with ms sql / sybase (t-sql) syntax !
> create table #mytable( title_id char(6), total_money_made money ) insert 
> into #mytable select title_id, total_money_made=sum( ytd_sales*price ) 
> from titles group by title_id select * from #mytable drop table #mytable
> Of course odbc driver for postgresql reports a syntax error due to the 
> table name !
> There is a way to do this with postgres ?!?

If you can't change the program to quote the table names, you do have the
option to hack the ODBC driver or Postgres itself to allow # in table

In response to

pgsql-novice by date

Next:From: Bruno Wolff IIIDate: 2005-04-23 17:38:44
Subject: Re: SSL use
Previous:From: Michael FuhrDate: 2005-04-23 06:23:14
Subject: Re: Base type ...and array of base type

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group