postgresqlpostgisraster
Unable to import raster data to postgis
I have been trying to import my SRTM raster data into my postgis using the command, but has generated the following error (tried multiple times). Is there any thing missing? I appreciate for any help
Error message:
ERROR: relation "test" already exists
ERROR: current transaction is aborted, commands ignored until end of transaction block
Solution
Welcome to SO.
The error message says you're trying to create a relation that already exists. Either drop it in your database ..
DROP TABLE test;
.. or tell raster2pgsql to do it for your by adding the parameter -d to your command.
-d Drops the table, then recreates it and populates
Something like
raster2pgsql -I -z 10x10 -C -F -s 4326 file.hgt -d public.test | psql ...
An alterative is to use -a to append the data to an existing table
-a Appends raster into current table, must be exactly the same table schema.
- Recursive CTE in Postgresql
- Add missing dates in a table
- Cast value to type (TEXT) using string representation of type ("TEXT")
- Equivalent of FOUND_ROWS() function in Postgresql
- django.db.utils.ProgrammingError: column "role" of relation "APP_profile" does not exist
- How to convert SQLite SQL dump file to PostgreSQL?
- How do I change the timezone to UTC in postgres permanently?
- Export .csv file (with headers) from PostgreSQL table using PHP PDO, first data row missing
- Problem with PgBouncer auth method not same type
- Running Docker Compose in Visual Studio Throws Postgres Uninitialized Error
- How to set an Array column with an empty array as default in SQLAlchemy + Postgres
- How can I annotate my Django queryset with a count of related objects
- Why does an operation on real and a numeric inputs result in a double precision?
- Get data on different rows per ID on one row
- How to distinguish when FOUND is false from when row version is obsolete in a Postgres stored function
- sum case with left join
- Perform VACUUM FULL with JPA
- Postgres - How to use the AVG of the last number of rows and multiply it with another column?
- Prevent JPA from changing DB column data type
- Convert hex in text representation to decimal number
- Is it possible to efficiently change table and column names, using prisma?
- PGbouncer locking template1
- Django: using older version of postgresql
- Execute formatted query gives error for insert in postgres function
- How to read the function body of a Postgres standard-SQL function?
- Running PostgreSQL in memory only
- Get fatal error: server could not be contacted when running pgAdmin4. 'NoneType' object has no attribute 'value'
- Can't find the PostgreSQL client library (libpq)
- Docker-Compose failing to Build Container when using postgresql
- Find SUM and MAX in custom aggregate function