Re: table column with special characters

From: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
To: Rahul k <rahul817(at)yahoo(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: table column with special characters
Date: 2004-07-02 22:18:44
Message-ID: 20040702151706.I78595@megazone.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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(at)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.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Bruno Wolff III 2004-07-03 06:44:47 Re: [admin] 32mb scsi system
Previous Message Rahul k 2004-07-02 21:31:38 table column with special characters