postgresql

Postgresql – could not determine data type of parameter $1 (geometry)

CASE A SELECT ST_DistanceSphere( ST_GeomFromText('POINT(127.058923 37.242621)', 4326), "geometryType")as distance FROM "MyTable" WHERE ST_DistanceSphere( ST_GeomFromText('POINT(127.058923 37.242621)', 4326), "geometryType") < 500; CASE B SELECT ST_DistanceSphere( ST_GeomFromText('POINT(${longitude} ${latitude})', 4326), "geometryType")as distance FROM "MyTable" WHERE ST_DistanceSphere( ST_GeomFromText('POINT(${longitude} ${latitude})', 4326), "geometryType") < 500; When performing…

VIEW QUESTION

Postgresql – How to improve sort performance in a huge dataset of 20 million rows?

So I have this query which is extremely slow to run - SELECT "conversation".*, "teamBotLocation"."id" AS "teamBotLocation.id", "teamBotLocation"."name" AS "teamBotLocation.name" FROM "conversation" AS "conversation" LEFT OUTER JOIN "teamBotLocation" AS "teamBotLocation" ON "conversation"."teamBotLocationId" = "teamBotLocation"."id" WHERE "conversation"."teamBotId" = 'some_id' AND "conversation"."teamBotLocationId"…

VIEW QUESTION

PgAdmin4: column-related problem in PostgreSQL after performing the copy command

Two copy command syntaxes were tried, and the corresponding errors are shown below: 1. COPY smartphones(brand_name, model, price, rating, has_5g, has_nfc, has_ir_blaster, processor_brand, num_cores, processor_speed,battery_capacity, fast_charging_available, fast_charging, ram_capacity, internal_memory, screen_size, refresh_rate, num_rear_cameras, num_front_cameras, os, primary_camera_rear, primary_camera_front, extended_memory_available, extended_upto, resolution_width, resolution_height)from…

VIEW QUESTION
Back To Top
Search