Re: problem migratin from ms sql

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
names.