Untitled

mail@pastecode.io avatar
unknown
plain_text
3 years ago
841 B
1
Indexable
Never
table name: initial stock

    column_name    |     data_type     
-------------------+-------------------
 id                | integer
 store_code        | character varying
 department        | character varying
 product_group     | character varying
 product_category  | character varying
 classification    | character varying
 product_code      | character varying
 product_name      | character varying
 total_qty         | double precision
 qty_purchase      | character varying
 cost_selling_unit | character varying
 price             | character varying
 stage             | integer


\copy initial_stock(store_code, department, product_group, product_category, classification, product_code, product_name, total_qty, qty_purchase, cost_selling_unit) from '/Users/ipom/Documents/BKIVdata.csv' delimiter ',' csv encoding 'shift_jis';