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 786A0529A8 for ; Tue, 9 Aug 2005 23:20:28 -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 72821-09 for ; Wed, 10 Aug 2005 02:20:26 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id A7E6A52BC7 for ; Tue, 9 Aug 2005 23:20:24 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id j7A2KR8e021463; Tue, 9 Aug 2005 22:20:27 -0400 (EDT) To: Ben Kim Cc: "josh@segrestfarms.com" , pgsql-admin@postgresql.org Subject: Re: SQL Server 2000 to PostgreSQL 8.0.3 In-reply-to: References: Comments: In-reply-to Ben Kim message dated "Tue, 09 Aug 2005 15:59:59 -0500" Date: Tue, 09 Aug 2005 22:20:27 -0400 Message-ID: <21462.1123640427@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.006 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200508/126 X-Sequence-Number: 18445 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