Steve Crawford <scrawford@xxxxxxxxxxxxxxxxxxxx> 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 ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate