pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedtable 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>
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 22:18 Stephan Szabo <sszabo@megazone.bigpanda.com>
parent: Rahul k <rahul817@yahoo.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