naming conventions constraint
| От | Julian North |
|---|---|
| Тема | naming conventions constraint |
| Дата | |
| Msg-id | 001901c399a4$92145c40$0401a8c0@ANYAKA обсуждение исходный текст |
| Ответы |
Re: naming conventions constraint
|
| Список | pgsql-sql |
I'm at the very beginning of working with postgres. The aim is to replace / build a number of very large and very complex database currently residing in Oracle, MSSQL and Informix. In order to coordinate across a medium size DBA team I instituted a standard constraint naming convention suitable for the above 3 platforms. For example a foreign key would be FK_table#reftable#column. Unfortunately I don't appear to be able to use it with postgres. This is because I can't use the # character in constraint names. Does anybody have any suggestions as to an alternative that is also a single char? (I'm limited to 30 chars cos of oracle and manyof the current names at the limit). Any help appreciated, Julian.
В списке pgsql-sql по дате отправления: