Re: [pgadmin-support] Migrating from MS-Access to Postgresql

2002-03-28 Thread Dave Page
Title: Message   -Original Message-From: Dino Nardini [mailto:[EMAIL PROTECTED]] Sent: 28 March 2002 13:45To: Dave Page; 'Marc Cuypers'; [EMAIL PROTECTED]Subject: Re: [pgadmin-support] Migrating from MS-Access to Postgresql Hello,I ran into similiar pro

Re: [pgadmin-support] Migrating from MS-Access to Postgresql

2002-03-28 Thread Dino Nardini
Hello, I ran into similiar problems when migrating tables from MSSQL to Postgres.  Typically I create table names such as "TableName" and column names such as "TableID" in MSSQL.  If there exists a table called "TableName" and a column called "TableID" why won't the following query work in postgre

Re: [pgadmin-support] Migrating from MS-Access to Postgresql

2002-03-28 Thread Dave Page
Title: Message Hi,   Either change your query to:   SELECT * FROM "Invoices"   or, on the first step in the Migration Wizard, use the options to shift names to lower case, and re-migrate your data.   Of course, if you only have a few tables/columns you could just rename them in pgAdmin.