Vincenzo Romano wrote: > Hi all. > > I'm willing to change an BIGINT ID column (actually a SERIAL8) with a > BIGINT whose valules are (pseudo)random. > The main objective is to avoid guessability. > I whish I could also use it as the PK (as it's now) but that's not > really important now. > Any hint?
http://wiki.postgresql.org/wiki/Pseudo_encrypt -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general