We will use the techniques we've used in the previous recipe named Creating arbitrary 3D objects for PostGIS learn how to create and import a UAV-derived point cloud in PostGIS.
One caveat before we begin is that while we will be working with geospatial data, we will be doing so in relative space, rather than a known coordinate system. In other words, this approach will calculate our dataset in an arbitrary coordinate system. ST_Affine could be used in combination with the field measurements of locations to transform our data into a known coordinate system, but this is beyond the scope of this book.