HTTP/1.1 200 OK
Server: nginx/1.14.2
Date: Fri, 05 Mar 2021 14:03:46 GMT
Content-Type: image/jpeg
Content-Length: 196583
Last-Modified: Wed, 03 Mar 2021 18:20:45 GMT
Connection: close
ETag: "603fd37d-2ffe7"
Accept-Ranges: bytesкак именно история действий записывается в переменую
apt-get update && apt-get install -y nano nginx
nano /etc/nginx/sites-available/default # в location добавить "proxy_pass https://api.telegram.org/;"
service nginx reloadALTER TABLE companies ADD COLUMN geog geography(POINT 4326);
UPDATE companies SET geog = ST_MakePoint(lon,lat)::geogprahy;
CREATE INDEX idx_name ON companies USING GIST (company_id, geog);
EXPLAIN ANALYSE SELECT DISTINCT ON (company_id)
company_id
, ST_Distance(geog, CAST(ST_Point(83.96, 53.96) AS GEOGRAPHY)) as distance
FROM companies
ORDER BY company_id, distance DESC;