By anellaico
I’ve created a Managed PostgreSQL Database with the Postgis extension. It creates the spatial_ref_sys table with the list of supported reference projections for spatial queries. I need to add a new projection to spatial_ref_sys but it gives the error: permission denied for table spatial_ref_sys. I’ve used the doadmin user to create the extension and the table spatial_ref_sys is owned by postgres user. I can’t change the ownership, neither the permissions. How can I do that with my user privileges?
Thanks
Become a contributor for community
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
DigitalOcean Documentation
Full documentation for every DigitalOcean product.
Resources for startups and AI-native businesses
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
The developer cloud
Scale up as you grow — whether you're running one virtual machine or ten thousand.
Start building today
From GPU-powered inference and Kubernetes to managed databases and storage, get everything you need to build, scale, and deploy intelligent applications.
