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 What you are asking is a solution that is usually solved during data loading in the application code or with other SQL statements. 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.
Comments
Post a Comment