我有此查询,我想保存在csv文件或html中
select phone_number, count(driver_callsign), driver_callsign from archived_order where data like '%"ptt":3%' and completed is true and ds_id = 16 and created > (select current_date - interval '7 days') group by archived_order.phone_number, archived_order.driver_callsign HAVING COUNT(driver_callsign) > 1;
当我在psql控制台中使用它时-似乎很正常。有输出:
phone_number | count | driver_callsign
---------------+-------+-----------------
+380502270347 | 2 | 6686
+380502336770 | 2 | 4996
当我使用此命令时:
psql -t -A -F ';' -h localhost -U username -c "select phone_number, count(driver_callsign), driver_callsign from archived_order where data like '%"ptt":3%' and completed is true and ds_id = 16 and created > (select current_date - interval '1 days') group by archived_order.phone_number, archived_order.driver_callsign HAVING COUNT(driver_callsign) > 1;" > SomeName.csv
它在那里什么都没写。
如果有人可以帮助修复它,我将不胜感激。
你很亲近
尝试使用从控制台stdout
将查询的输出定向到文件psql
。以下示例在客户端计算机中创建一个文件:
$ psql -c "COPY (your query here!) TO STDOUT DELIMITER ';'" > file.csv
如果希望将此输出文件存储在服务器中,则可以尝试以下操作:
$ psql -c "COPY (your query here!) TO '/path/to/file.csv'"
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句