UUID generation functions
| От | Hyatt, Gordon |
|---|---|
| Тема | UUID generation functions |
| Дата | |
| Msg-id | 85AC2B55AEF4CC41A2145B60C7F88074026535@JDCMAIL4.joslin.harvard.edu обсуждение исходный текст |
| Ответы |
Re: UUID generation functions
|
| Список | pgsql-admin |
Sorry for the OT post, but does anyone know if there are any internal UUID generation functions in pg? I took a quick look at the 8.2 docs and didn't find anything related. I know I can spawn a call to the underlying system to get a UUID. The problem is that calling out to the system for this tends to lock one into a specific O/S. In the case of Linux, uuidgen is _usually_ available for this; on Windows, however, a custom app to call a specific API would be necessary. The idea I had was to call this internal UUID generation function in an INSERT trigger to generate a unique, traceable that identifies a sample as it traverses numerous information systems/databases. Thanks in advance, Gord Hyatt
В списке pgsql-admin по дате отправления: