c++ - Generating unique ID in postgres -


Is there any way to generate a unique ID in postgres? Suppose I have two files:

File 1:
a, b, c, d, e, f

file2:
h, i, j < Br> a, f, h

and I want to include them in the same table (which should be possible because they have the same data type elements) but still able to obtain them, Separately later, can I get postgrescale for generating a unique ID for me?

You can definitely do it! You can create a loaded_files table and you can store the name of the file you are loading ID from loaded_files and Insert that data into your file_items table.

What you are asking is a solution that is usually solved during data loading in the application code or with other SQL statements.

Comments