Postgres Pro
Downloads
Home   >   mailing lists

Re: overwrite column data select - Postgres 9.2 - Mailing list pgsql-general

From Patrick B
Subject Re: overwrite column data select - Postgres 9.2
Date
Msg-id CAJNY3ivVGbNLOSfcrM08=Z1NTv_S7O=Owea_yNwk-fmu0eaH3Q@mail.gmail.com
Whole thread Raw
In response to Re: overwrite column data select - Postgres 9.2  (Patrick B <patrickbakerbr@gmail.com>)
List pgsql-general
Tree view

Rather than test.UID.@example.com I was hoping for values such as:

test.4645364.@example.com

test.8786756.@example.com


With UNIQUE UUID


is that possible?



I was able to do that using:

SELECT cast(''test.''|| uuid_generate_v1() AS varchar(30)) || ''@example.com''

pgsql-general by date:

Previous
From: CS DBA
Date:
Subject: json select question
Next
From: John R Pierce
Date:
Subject: Re: json select question