Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Tue, 08 Jan 2008 16:58:46 -0500
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
- References:
- All numeric database names?
- From: Chris Hoover
- Re: All numeric database names?
- From: Steve Crawford
- All numeric database names?
- Prev by Date: Re: All numeric database names?
- Next by Date: Re: -d option in pg_dump
- Previous by thread: Re: All numeric database names?
- Next by thread: -d option in pg_dump
- Indexes: