pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
table column with special characters
2+ messages / 2 participants
[nested] [flat]

* table column with special characters
@ 2004-07-02 21:31 Rahul k <rahul817@yahoo.com>
  2004-07-02 22:18 ` Re: table column with special characters Stephan Szabo <sszabo@megazone.bigpanda.com>
  0 siblings, 1 reply; 2+ messages in thread

From: Rahul k @ 2004-07-02 21:31 UTC (permalink / raw)
  To: pgsql-admin

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 



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: table column with special characters
  2004-07-02 21:31 table column with special characters Rahul k <rahul817@yahoo.com>
@ 2004-07-02 22:18 ` Stephan Szabo <sszabo@megazone.bigpanda.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Stephan Szabo @ 2004-07-02 22:18 UTC (permalink / raw)
  To: Rahul k <rahul817@yahoo.com>; +Cc: 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@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.




^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2004-07-02 22:18 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-07-02 21:31 table column with special characters Rahul k <rahul817@yahoo.com>
2004-07-02 22:18 ` Stephan Szabo <sszabo@megazone.bigpanda.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox