[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
- Subject: Importing Data
- From: Dave Babb <..hidden..>
- Date: Tue, 4 Oct 2011 19:30:13 +0000 (UTC)
I am not an SQL savvy individual. As I am moving test data from a QuickBooks
generated CSV file that has been reordered to match the table structure of a
given entity within LedgerSMB, I have need of generating that ID field when I
The line I'm using to import data from the properly organized CSV file is:
"ACI=# copy employee from
'/home/dcbdbis/Documents/ACI-CSV-Files/ReorganizedEmployee.csv' with delimiter
Of course it's having an issue with the ID field. This may be a dumb question to
SQL savvy folks out there (which I am not), but how do I tell SQL to generate
that ID field for itself for indexng/sorting purposes?
I have been told that this field should not be manually manipulated.
Do I need to leave a blank field for it (as it is the first field) in the CSV
file, and/or do I need to put into it some special contents that would trigger
SQL to generate this field? Or something else?
Assistance will be appreciated.
Sincerely and respectfully,