Re: All numeric database names?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Steve Crawford <scrawford(at)pinpointresearch(dot)com>
Cc: Chris Hoover <revoohc(at)gmail(dot)com>, "pgsql-admin(at)postgresql(dot)org Admin" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: All numeric database names?
Date: 2008-01-08 21:58:46
Message-ID: 14709.1199829526@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Steve Crawford <scrawford(at)pinpointresearch(dot)com> writes:
> Alternately, you could prepend 1+ alpha characters to the customer
> numbers to create names like c123456 or cust123456 which don't need to
> be quote-enclosed.

I'd recommend that too. Quite aside from the quoting problem, this
will save you tons of confusion if you ever have to deal with database
OIDs (during disaster recovery perhaps).

regards, tom lane

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2008-01-08 22:23:01 Re: -d option in pg_dump
Previous Message Steve Crawford 2008-01-08 20:59:11 Re: All numeric database names?