score:1
Accepted answer
You can use row_to_json and array_to_string in your query.
See below an example.
SELECT array_to_string(array( SELECT row_to_json(products.*) FROM products),', ') as jsonData;
Hope this will help!
Source: stackoverflow.com
Related Query
- how to convert data selected from a postgres database to json or csv to use it with d3js lib?
- How do I convert strings from csv in d3.js and be able to use them as a dataset?
- How to use attr fill with scalesqrt using data from another json file?
- How can I parse csv data from a javascript array of strings for use in d3 graphs
- Angular How to use data from json in c3?
- How to convert CSV Data to JSON Object
- How do I use JSON data in D3 which was received from WEB-Service?
- How to use translate in d3 when data is loaded from external json
- How can I use my data from a JSON string to populate dimple d3.js line chart?
- how to import php script that convert mysql data to json format, from d3.json function in force directed layout
- How to load data from a CSV file in D3 v5
- How to load data from an internal JSON array rather than from an external resource / file for a collapsible tree in d3.js?
- How to pull data from mysql database and visualize with D3.JS?
- How to update elements of an HTML that the elements are created using data from a CSV file?
- Convert a d3 chart to load data from json inside a variable
- D3 Library — How To Access Data from JSON in this example
- How can I efficiently convert data from string to int within a d3 method chain?
- How do I use d3.domain to get d3.min and d3.max from multiple columns in a JSON file?
- D3.js : How to read data from JSON in Grouped Bar Chart
- how to get data with tsv or csv to array in d3.js from a txt file?
- How to use python pandas to get intersection of sets from a csv file
- How to create d3 graph using data from Rails database
- grouped bar chart from JSON data instead of CSV
- How to load external JSON data from a Web API in d3.js?
- How to read JSON data from same json for tree layout insteadof reading from other .JSON file?
- How to fetch data from json file to draw a dynamic graph by using d3.js
- how to visualize data from mysql database in force layout of d3 tool
- In a d3 scatterplot using data from a csv file, how do i draw lines connecting related points when the mouse is over a point?
- How to use the quantize function with my json data file
- how to convert the json to csv
More Query from same tag
- how to display dates in selected month and year dc.js
- NVD3 arcTween func throwing undefined error
- How can I write a piece of text over my rectangles in D3?
- (d3.js) How to create labels outside arcs?
- d3 use drop down to filter for column headers
- Highlighting child nodes in D3js v4
- d3 domain y not animating during legend toggles
- Large gap between columns in D3js column chart
- D3.js Update Pattern Confusion
- Creating world choropleth map with D3
- ember-data as data for d3
- D3.js integration with Wikipedia
- Center D3 geoPath US map within svg
- d3 height function returns NaN
- d3.tsv to load tsv file not working
- Filling D3.js Pie Graph with SQL Query
- Filter out nodes and turn them inactive
- D3 charts and JSON
- d3 axes not appearing
- semantic zoom and panning d3.js v4
- Why is my click event on my dynamically added D3 node not firing?
- Plotting points on a map with D3
- How to add events to the individual sections(arcs) of a pie chart created out of d3.js?
- Cocktail recipe Data Visualisation
- d3.js Multi-series line chart interactive (tsv into literal data)
- Multiple NVD3 charts on page. How to simplify the javascript code and wrap function?
- Converting seconds to minutes and formatting axes
- clip path formed by a set of squares in a group
- D3 + Leaflet: d3.geo.path() resampling
- Drawing Kenyan counties d3.geo.path()
