Sunday, 9 June 2019

postgresql - How do I create and manage custom SQL functions in CartoDB?


I'm working through a CartoDB tutorial at the moment, and got to the point of creating a custom SQL function.


Do I just write this in the "CUSTOM SQL QUERY" Field on the right of my table? CUSTOM SQL QUERY How do I edit previously created functions?



Answer



The Custom SQL query panel of the CartoDB user interface isn't tied to any particular table, but it commonly is used to select the single table you are currently looking at.


So with that, yep, just drop your custom function in their and run it. After it is loaded into your database, you should be able to go back to selecting from your table just like normal.


No comments:

Post a Comment

arcpy - Changing output name when exporting data driven pages to JPG?

Is there a way to save the output JPG, changing the output file name to the page name, instead of page number? I mean changing the script fo...