Hola Rafael.
You could generate a UUID. There is a contrib module in
contrib/uuid-ossp with several functions in order to generate an UUID with different
algorithms, as documentation says.
If you don’t want to use these functions because you use
an specific format, perhaps they could serve you as example in order to create a
custom one.
Espero haberte dado alguna idea.
De: Luis Dominguez
[mailto:bcld@xxxxxxxxxxx]
Enviado el: jueves, 11 de febrero de 2010 14:36
Para: pgsql-es-ayuda@xxxxxxxxxxxxxx; vepug@xxxxxxxxxxxxxx;
pgsql-admin@xxxxxxxxxxxxxx
Asunto: REF: Data Migration MS SQL Server 7.0 to PostgreSQL 8.4
on Linux
Good morning, I am now in
the process of migrating a database from a driver ms sql server 7.0 to
postgresql 8.4 vesion but I have a problem with the data type (timestamp) SQL
Server 7.0 that refers to a single binary field that is updated randomly by
row, and this field is paramount in my application for purposes of monitoring,
postgresql 8.4 now also have the same timestamp but refers to other data (date
+ time), I investigated other types of data such as (serial, uuid, xid, byte
etc) in postgresql and not get something just to replace it, I thought of a
function that do something similar but not yet tried, and of course I turn to
you to see if I can lend a hand with this rut that I have right now ....¡
