Use of the Postgresql uuid.

PostgreSQL built-in UUID type, performance is good, but PostgreSQL by default does not install UUID related operation function, need to manually import.

Import UUID-related functions.

psql-d dbname-u dbuser-f D:/develop/database/postgresql/9.3/share/contrib/uuid-ossp.sql

Defines the UUID as the primary key and automatically generates the primary key

reate TABLE data_2014.test (uid uuid not NULL DEFAULT uuid_generate_v1 (), name character varying (+), CONSTRAINT test_p Key PRIMARY key (UID)) with (Oids=false);

The UUID function is built into Java, and when the data volume is large, there have been duplicate keys, causing the system to malfunction.

Java.util.UUID.randomUUID (). toString ();

In addition, you can use Com.eaio.uuid.UUID

New Com.eaio.uuid.UUID (). toString ();

Use of the Postgresql uuid.