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 BB723D1B504 for ; Fri, 2 Jul 2004 19:18:54 -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 04933-01 for ; Fri, 2 Jul 2004 22:18:48 +0000 (GMT) Received: from megazone.bigpanda.com (megazone.bigpanda.com [64.147.171.210]) by svr1.postgresql.org (Postfix) with ESMTP id 72162D1B528 for ; Fri, 2 Jul 2004 19:18:42 -0300 (ADT) Received: by megazone.bigpanda.com (Postfix, from userid 1001) id E213F358F8; Fri, 2 Jul 2004 15:18:44 -0700 (PDT) Received: from localhost (localhost [127.0.0.1]) by megazone.bigpanda.com (Postfix) with ESMTP id E0B50358C3; Fri, 2 Jul 2004 15:18:44 -0700 (PDT) Date: Fri, 2 Jul 2004 15:18:44 -0700 (PDT) From: Stephan Szabo To: Rahul k Cc: pgsql-admin@postgresql.org Subject: Re: table column with special characters In-Reply-To: <20040702213138.58043.qmail@web41606.mail.yahoo.com> Message-ID: <20040702151706.I78595@megazone.bigpanda.com> References: <20040702213138.58043.qmail@web41606.mail.yahoo.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200407/59 X-Sequence-Number: 14127 On Fri, 2 Jul 2004, Rahul k wrote: > I need to query a table with column name having > special characters ":", "@", "/", for example: > ab:cde12n/5k@90m You'd need to double quote the name on creation and on any usage of the name (for example in a select list or expression) in SQL statements.