Re: table column with special characters - Mailing list 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.