First consider the following table:
create table taxon ( taxonid serial, descr text);
As I understand it, "serial" means that column will automatically populate with a numerical key.
If I want to fill the field 'descr' with a list of scientific names stored in a spreadsheet, then how would I proceed?
I have a spreadsheet that has about a dozen columns. I copied the field with scientific names into a new spreadsheet. Then I created an empty field on the left. So I have a spreadsheet with two columns. I saved it as a CSV file.
When I try to import it with pgAdmin III, I get the error message
WARNING: null value in column "taxonid" violates non-null constraint
How can I import that single column into the second column in this table? Thanks.