“segment” : [ { “coordinates”:[ { “x”:703.944, “y”:1133.952 }, { “x”:703.944, “y”:1014.912 } ] }, { “coordinates”:[ { “x”:111.944, “y”:11.952 }, { “x”:703.944, “y”:1014.912 } ] } ] for example i wanna insert ROI values in Psql. what type colunms do i have to make it. to insert just json data?.. i just search pgis […]

I have a Java application where I run a COPY command. In this command, I copy the query result to stdout in csv format.

The database has a “clients” table.

j’ai réussit à connecter mon back end à ma base de donnée postgresql , sauf que je n’arrive toujours pas à créer de nouveaux éléments dans ma table .

I need to extract some unit from a date for further use in conditions. I found sql function date_part() and wrote following method: