docker postgres bash insert data
使用了docker postgres, 想要在命令行执行脚本直接创建数据,可以这样:
docker <span style="color:#f5ab35">exec</span> id psql -U postgres(user_name) -d database_name -c <span style="color:#abe338">"INSERT INTO table_name (column) VALUES ('name')"</span>如果是多列都增加可以使用例如:
docker <span style="color:#f5ab35">exec</span> abc psql -U postgres -d asdf -c <span style="color:#abe338">"INSERT INTO calculation_templates (algorithm_name, initial_discharge_rate, initial_filling_amount, operating_discharge_rate, maintenance_discharge_rate, maintenance_filling_rate, annual_maintenance_rate, scrap_discharge_rate, factor_tui_yi, factor_by_year, factor_production) VALUES ('算法名称', 0.01, 10, 0.02, 0.03, 0.04, 0.05, 0.06, 0.07, 0.08, 0.09)"</span>