X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 0A88F52977 for ; Wed, 10 Aug 2005 14:21:13 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 62773-04 for ; Wed, 10 Aug 2005 17:21:05 +0000 (GMT) Received: from mail.segrestfarms.com (unknown [65.124.195.241]) by svr1.postgresql.org (Postfix) with SMTP id C48D1528DF for ; Wed, 10 Aug 2005 14:21:01 -0300 (ADT) Received: (qmail 8037 invoked by uid 399); 10 Aug 2005 17:19:02 -0000 Received: from unknown (HELO njord.segrestfarms.com) (65.124.195.227) by 65-124-195-241.dia.cust.qwest.net with SMTP; 10 Aug 2005 17:19:02 -0000 Received: from [192.100.100.176] (unknown [192.100.100.176]) by njord.segrestfarms.com (Postfix) with ESMTP id CF8DA80AE1E; Wed, 10 Aug 2005 17:32:13 -0400 (EDT) Message-ID: <42FA3760.9050407@segrestfarms.com> Date: Wed, 10 Aug 2005 13:20:32 -0400 From: "josh@segrestfarms.com" User-Agent: Mozilla Thunderbird 1.0.2 (Windows/20050317) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Cc: Tom Lane , Ben Kim Subject: Re: SQL Server 2000 to PostgreSQL 8.0.3 References: <21462.1123640427@sss.pgh.pa.us> In-Reply-To: <21462.1123640427@sss.pgh.pa.us> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=2.803 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO, RCVD_IN_DSBL X-Spam-Level: ** X-Archive-Number: 200508/133 X-Sequence-Number: 18452 I have successfully migrated my db from SQL Server to PostgreSQL. (Aqua Data Studio 4.0 did the trick) Now, I need to move this PG db from its current installation on Windows over to my RedHat box. So, I performed a Backup on my Windows machine and saved the .backup file to my Windows Desktop. I used WinSCP to copy the .backup file from my Windows Desktop over to my RedHat root/Desktop. Then I swivel over to my RedHat machine and I open up PGAdminIII (excited because I'm thinking I've about got this migration complete) and unfortunately under the Tools menu, the Backup and Restore selections are disabled (grayed out). And so I'm a little stumped. Surely there is a workaround, but I have yet to discover it. Thanks in advance for any help you might be able provide. Tom Lane wrote: >Ben Kim writes: > > >>>In reviewing my tables, I found that for some strange reason a handful >>>of fields are not double-quoted. Strange quirk: >>>... >>> >>> > > > >>In my case, DTS's "create" always wrapped the field names with double >>quote. The script seems to me not from DTS. >> >> > >I think it's from pg_dump. pg_dump (and most other PG-related tools) >will only quote names that need to be quoted per the PG rules ... >in other words, if it's all lower case, it does not need quotes. > > regards, tom lane > > > >