jeudi 29 janvier 2015

Export Postgres table as json


Is there a way to export postgres table data as json to a file? I need the output to be line by line, like:



{'id':1,'name':'David'}
{'id':2,'name':'James'}
...


EDIT: postgres version: 9.3.4





Aucun commentaire:

Enregistrer un commentaire