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 9BC45D1B500 for ; Fri, 2 Jul 2004 18:31:47 -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 83510-04 for ; Fri, 2 Jul 2004 21:31:40 +0000 (GMT) Received: from web41606.mail.yahoo.com (web41606.mail.yahoo.com [66.218.93.106]) by svr1.postgresql.org (Postfix) with SMTP id A8290D1B29D for ; Fri, 2 Jul 2004 18:31:36 -0300 (ADT) Message-ID: <20040702213138.58043.qmail@web41606.mail.yahoo.com> Received: from [63.209.4.196] by web41606.mail.yahoo.com via HTTP; Fri, 02 Jul 2004 14:31:38 PDT Date: Fri, 2 Jul 2004 14:31:38 -0700 (PDT) From: Rahul k Subject: table column with special characters To: pgsql-admin@postgresql.org 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.9 tagged_above=0.0 required=5.0 tests=FROM_ENDS_IN_NUMS X-Spam-Level: X-Archive-Number: 200407/58 X-Sequence-Number: 14126 Hi, I need to query a table with column name having special characters ":", "@", "/", for example: ab:cde12n/5k@90m When performing a select on this column I get this error: ERROR: parser: parse error at or near ":" Any suggestions how to escape these special characters? thanks rk __________________________________ Do you Yahoo!? New and Improved Yahoo! Mail - 100MB free storage! http://promotions.yahoo.com/new_mail