I have a Postgresql database with a column type of
text. Coming from a SQL Server background, is this equivalent to the
My specific example/reason for asking this question, is that I have a table with a column of type
text in which I would like to store unique values. The table is updated according to regular CSV imports, meaning that for every row in the CSV the the
text column is checked for an existing entry (a column-value in the CSV), and if none is found then that value is inserted into the table.
My understanding is that this could mean checking thousands (or maybe hundreds of thousands) of
text values against other
text values. I imagine this to be incredibly inneficient. Is this the case?