adding values to trait_coveraite_associations to enable bulk uploads

trait_covariate_associations.sql

INSERT INTO . ("trait_variable_id", "covariate_variable_id", "required", "id") VALUES ('39', '343', 'f', '1');
INSERT INTO . ("trait_variable_id", "covariate_variable_id", "required", "id") VALUES ('492', '343', 'f', '2');
INSERT INTO . ("trait_variable_id", "covariate_variable_id", "required", "id") VALUES ('568', '343', 'f', '3');
INSERT INTO . ("trait_variable_id", "covariate_variable_id", "required", "id") VALUES ('15', '80', 'f', '4');
INSERT INTO . ("trait_variable_id", "covariate_variable_id", "required", "id") VALUES ('4', '80', 'f', '5');
INSERT INTO . ("trait_variable_id", "covariate_variable_id", "required", "id") VALUES ('546', '80', 'f', '6');
INSERT INTO . ("trait_variable_id", "covariate_variable_id", "required", "id") VALUES ('404', '80', 'f', '7');
INSERT INTO . ("trait_variable_id", "covariate_variable_id", "required", "id") VALUES ('38', '80', 'f', '8');
INSERT INTO . ("trait_variable_id", "covariate_variable_id", "required", "id") VALUES ('5', '80', 'f', '9');
INSERT INTO . ("trait_variable_id", "covariate_variable_id", "required", "id") VALUES ('7', '80', 'f', '10');
INSERT INTO . ("trait_variable_id", "covariate_variable_id", "required", "id") VALUES ('546', '81', 't', '11');
INSERT INTO . ("trait_variable_id", "covariate_variable_id", "required", "id") VALUES ('404', '81', 't', '12');
INSERT INTO . ("trait_variable_id", "covariate_variable_id", "required", "id") VALUES ('38', '81', 't', '13');
INSERT INTO . ("trait_variable_id", "covariate_variable_id", "required", "id") VALUES ('4', '81', 't', '14');
INSERT INTO . ("trait_variable_id", "covariate_variable_id", "required", "id") VALUES ('5', '81', 't', '15');
INSERT INTO . ("trait_variable_id", "covariate_variable_id", "required", "id") VALUES ('7', '81', 't', '16');
INSERT INTO . ("trait_variable_id", "covariate_variable_id", "required", "id") VALUES ('10', '80', 'f', '17');
INSERT INTO . ("trait_variable_id", "covariate_variable_id", "required", "id") VALUES ('11', '80', 'f', '18');
INSERT INTO . ("trait_variable_id", "covariate_variable_id", "required", "id") VALUES ('31', '80', 'f', '19');
INSERT INTO . ("trait_variable_id", "covariate_variable_id", "required", "id") VALUES ('70', '80', 'f', '20');
INSERT INTO . ("trait_variable_id", "covariate_variable_id", "required", "id") VALUES ('572', '191', 'f', '21');
INSERT INTO . ("trait_variable_id", "covariate_variable_id", "required", "id") VALUES ('572', '243', 'f', '22');
INSERT INTO . ("trait_variable_id", "covariate_variable_id", "required", "id") VALUES ('572', '343', 'f', '23');
INSERT INTO . ("trait_variable_id", "covariate_variable_id", "required", "id") VALUES ('62', '343', 'f', '24');
INSERT INTO . ("trait_variable_id", "covariate_variable_id", "required", "id") VALUES ('63', '343', 'f', '25');
INSERT INTO . ("trait_variable_id", "covariate_variable_id", "required", "id") VALUES ('546', '343', 'f', '26');
INSERT INTO . ("trait_variable_id", "covariate_variable_id", "required", "id") VALUES ('404', '343', 'f', '27');
INSERT INTO . ("trait_variable_id", "covariate_variable_id", "required", "id") VALUES ('70', '343', 'f', '28');
INSERT INTO . ("trait_variable_id", "covariate_variable_id", "required", "id") VALUES ('38', '343', 'f', '29');
INSERT INTO . ("trait_variable_id", "covariate_variable_id", "required", "id") VALUES ('31', '343', 'f', '30');
INSERT INTO . ("trait_variable_id", "covariate_variable_id", "required", "id") VALUES ('15', '343', 'f', '31');
INSERT INTO . ("trait_variable_id", "covariate_variable_id", "required", "id") VALUES ('11', '343', 'f', '32');
INSERT INTO . ("trait_variable_id", "covariate_variable_id", "required", "id") VALUES ('493', '343', 'f', '33');
INSERT INTO . ("trait_variable_id", "covariate_variable_id", "required", "id") VALUES ('10', '343', 'f', '34');
INSERT INTO . ("trait_variable_id", "covariate_variable_id", "required", "id") VALUES ('7', '343', 'f', '35');
INSERT INTO . ("trait_variable_id", "covariate_variable_id", "required", "id") VALUES ('5', '343', 'f', '36');
INSERT INTO . ("trait_variable_id", "covariate_variable_id", "required", "id") VALUES ('4', '343', 'f', '37');
INSERT INTO . ("trait_variable_id", "covariate_variable_id", "required", "id") VALUES ('304', '343', 'f', '38');
INSERT INTO . ("trait_variable_id", "covariate_variable_id", "required", "id") VALUES ('56', '343', 'f', '39');
INSERT INTO . ("trait_variable_id", "covariate_variable_id", "required", "id") VALUES ('256', '343', 'f', '40');
INSERT INTO . ("trait_variable_id", "covariate_variable_id", "required", "id") VALUES ('18', '343', 'f', '41');
INSERT INTO . ("trait_variable_id", "covariate_variable_id", "required", "id") VALUES ('604', '343', 'f', '42');
INSERT INTO . ("trait_variable_id", "covariate_variable_id", "required", "id") VALUES ('348', '343', 'f', '43');
INSERT INTO . ("trait_variable_id", "covariate_variable_id", "required", "id") VALUES ('538', '343', 'f', '44');
INSERT INTO . ("trait_variable_id", "covariate_variable_id", "required", "id") VALUES ('603', '343', 'f', '45');
INSERT INTO . ("trait_variable_id", "covariate_variable_id", "required", "id") VALUES ('9', '80', 'f', '46');
INSERT INTO . ("trait_variable_id", "covariate_variable_id", "required", "id") VALUES ('9', '81', 'f', '47');
INSERT INTO . ("trait_variable_id", "covariate_variable_id", "required", "id") VALUES ('9', '343', 'f', '48');
INSERT INTO . ("trait_variable_id", "covariate_variable_id", "required", "id") VALUES ('9', '136', 'f', '49');
INSERT INTO . ("trait_variable_id", "covariate_variable_id", "required", "id") VALUES ('8', '343', 'f', '50');
INSERT INTO . ("trait_variable_id", "covariate_variable_id", "required", "id") VALUES ('8', '81', 'f', '51');
INSERT INTO . ("trait_variable_id", "covariate_variable_id", "required", "id") VALUES ('8', '80', 'f', '52');
INSERT INTO . ("trait_variable_id", "covariate_variable_id", "required", "id") VALUES ('8', '136', 'f', '53');
INSERT INTO . ("trait_variable_id", "covariate_variable_id", "required", "id") VALUES ('17', '391', 'f', '54');
INSERT INTO . ("trait_variable_id", "covariate_variable_id", "required", "id") VALUES ('8', '6', 'f', '55');
INSERT INTO . ("trait_variable_id", "covariate_variable_id", "required", "id") VALUES ('9', '6', 'f', '56');
INSERT INTO . ("trait_variable_id", "covariate_variable_id", "required", "id") VALUES ('566', '343', 'f', '57');
INSERT INTO . ("trait_variable_id", "covariate_variable_id", "required", "id") VALUES ('6', '81', 't', '58');
INSERT INTO . ("trait_variable_id", "covariate_variable_id", "required", "id") VALUES ('414', '191', 'f', '59');
INSERT INTO . ("trait_variable_id", "covariate_variable_id", "required", "id") VALUES ('414', '243', 'f', '60');
INSERT INTO . ("trait_variable_id", "covariate_variable_id", "required", "id") VALUES ('414', '300', 'f', '61');
INSERT INTO . ("trait_variable_id", "covariate_variable_id", "required", "id") VALUES ('56', '191', 'f', '62');
INSERT INTO . ("trait_variable_id", "covariate_variable_id", "required", "id") VALUES ('56', '243', 'f', '63');
INSERT INTO . ("trait_variable_id", "covariate_variable_id", "required", "id") VALUES ('56', '300', 'f', '64');

@dlebauer

[sserbin@modex Data]$ psql -U bety -d bety -a -f trait_covariate_associations.sql
INSERT INTO . ("trait_variable_id", "covariate_variable_id", "required", "id") VALUES ('39', '343', 'f', '1');
psql:trait_covariate_associations.sql:1: ERROR:  syntax error at or near "."
LINE 1: INSERT INTO . ("trait_variable_id", "covariate_variable_id",...
                    ^
INSERT INTO . ("trait_variable_id", "covariate_variable_id", "required", "id") VALUES ('492', '343', 'f', '2');
psql:trait_covariate_associations.sql:2: ERROR:  syntax error at or near "."
LINE 1: INSERT INTO . ("trait_variable_id", "covariate_variable_id",...
                    ^
INSERT INTO . ("trait_variable_id", "covariate_variable_id", "required", "id") VALUES ('568', '343', 'f', '3');
psql:trait_covariate_associations.sql:3: ERROR:  syntax error at or near "."
LINE 1: INSERT INTO . ("trait_variable_id", "covariate_variable_id",...
                    ^
INSERT INTO . ("trait_variable_id", "covariate_variable_id", "required", "id") VALUES ('15', '80', 'f', '4');
psql:trait_covariate_associations.sql:4: ERROR:  syntax error at or near "."
LINE 1: INSERT INTO . ("trait_variable_id", "covariate_variable_id",...
                    ^

Not sure but I am not formatting properly?

Should it be INSERT INTO trait_covariate_associations ("tra....)?

INSERT INTO trait_covariate_associations ("trait_variable_id", "covariate_variable_id", "required", "id") VALUES ('39', '343', 'f', '1');
INSERT INTO trait_covariate_associations ("trait_variable_id", "covariate_variable_id", "required", "id") VALUES ('492', '343', 'f', '2');
INSERT INTO trait_covariate_associations ("trait_variable_id", "covariate_variable_id", "required", "id") VALUES ('568', '343', 'f', '3');
INSERT INTO trait_covariate_associations ("trait_variable_id", "covariate_variable_id", "required", "id") VALUES ('15', '80', 'f', '4');
INSERT INTO trait_covariate_associations ("trait_variable_id", "covariate_variable_id", "required", "id") VALUES ('4', '80', 'f', '5');
INSERT INTO trait_covariate_associations ("trait_variable_id", "covariate_variable_id", "required", "id") VALUES ('546', '80', 'f', '6');
INSERT INTO trait_covariate_associations ("trait_variable_id", "covariate_variable_id", "required", "id") VALUES ('404', '80', 'f', '7');
INSERT INTO trait_covariate_associations ("trait_variable_id", "covariate_variable_id", "required", "id") VALUES ('38', '80', 'f', '8');
INSERT INTO trait_covariate_associations ("trait_variable_id", "covariate_variable_id", "required", "id") VALUES ('5', '80', 'f', '9');
INSERT INTO trait_covariate_associations ("trait_variable_id", "covariate_variable_id", "required", "id") VALUES ('7', '80', 'f', '10');
INSERT INTO trait_covariate_associations ("trait_variable_id", "covariate_variable_id", "required", "id") VALUES ('546', '81', 't', '11');
INSERT INTO trait_covariate_associations ("trait_variable_id", "covariate_variable_id", "required", "id") VALUES ('404', '81', 't', '12');
INSERT INTO trait_covariate_associations ("trait_variable_id", "covariate_variable_id", "required", "id") VALUES ('38', '81', 't', '13');
INSERT INTO trait_covariate_associations ("trait_variable_id", "covariate_variable_id", "required", "id") VALUES ('4', '81', 't', '14');
INSERT INTO trait_covariate_associations ("trait_variable_id", "covariate_variable_id", "required", "id") VALUES ('5', '81', 't', '15');
INSERT INTO trait_covariate_associations ("trait_variable_id", "covariate_variable_id", "required", "id") VALUES ('7', '81', 't', '16');
INSERT INTO trait_covariate_associations ("trait_variable_id", "covariate_variable_id", "required", "id") VALUES ('10', '80', 'f', '17');
INSERT INTO trait_covariate_associations ("trait_variable_id", "covariate_variable_id", "required", "id") VALUES ('11', '80', 'f', '18');
INSERT INTO trait_covariate_associations ("trait_variable_id", "covariate_variable_id", "required", "id") VALUES ('31', '80', 'f', '19');
INSERT INTO trait_covariate_associations ("trait_variable_id", "covariate_variable_id", "required", "id") VALUES ('70', '80', 'f', '20');
INSERT INTO trait_covariate_associations ("trait_variable_id", "covariate_variable_id", "required", "id") VALUES ('572', '191', 'f', '21');

...

This is the way it worked for me