Re: [PATCHES] dollar quoting

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [PATCHES] dollar quoting
Date: 2004-02-15 20:55:36
Message-ID: 402FDCC8.5000103@dunslane.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches


Another interesting thing abut psql that I noticed when using '$' in
identifiers is this effect:

andrew=# create table ab$cd$ef (ef$cd$ab text);
CREATE TABLE
andrew=# \d ab$cd$ef
Did not find any relation named "ab$cd$ef".
andrew=# \d ab\$cd\$ef
Table "public.ab$cd$ef"
Column | Type | Modifiers
----------+------+-----------
ef$cd$ab | text |

which is perhaps slightly less than intuitive.

cheers

andrew

>
>

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Hans-Jürgen Schönig 2004-02-15 21:15:50 Re: No Timeout in SELECT..FOR UPDATE
Previous Message Tom Lane 2004-02-15 18:13:04 Re: Proposals for PITR

Browse pgsql-patches by date

  From Date Subject
Next Message Chris Campbell 2004-02-15 21:50:41 Crash when calling a pl/pgsql function with no row to pass as an argument
Previous Message Peter Eisentraut 2004-02-15 19:40:15 Re: Afrikaans translation of libpq