Top "Postgis" questions

good postgresql client for windows?

coming back to postgresql after several years of oracle ... what are the state-of-the art postgresql administrative/ddl generating/data inserting …

windows postgresql frontend postgis

Which data type for latitude and longitude?

I am newbie to PostgreSQL and PostGIS. I want to store latitude and longitude values in PostgreSQL 9.1.1 database table. I …

postgresql types latitude-longitude postgis

Get PostGIS version

How can I find out which version of PostGIS I have?

postgresql postgis

JPA/Hibernate Native Queries do not recognize Parameters

I am using Hibernate/JPA to execute native PostGIS queries. The problem with these queries is that they need parameters …

java hibernate orm jpa postgis

Postgis installation: type "geometry" does not exist

I am trying to create table with Postgis. I do it by this page. But when I import postgis.sql …

postgresql geometry postgis

PostgreSQL ERROR: 42P01: relation "[Table]" does not exist

I'm having this strange problem using PostgreSQL 9.3 with tables that are created using qoutes. For instance, if I create a …

sql database postgresql postgis

Psycopg2 Insert Into Table with Placeholders

This might be a rather silly question but what am I doing wrong here? It creates the table but the …

python postgresql postgis psycopg2 psycopg

How do I add PostGIS to PostgreSQL pgAdmin?

I've got PostgreSQL and pgAdmin installed, but I want to add a PostGIS server so I could work on a …

postgresql postgis pgadmin

FATAL ERROR lock file "postmaster.pid" already exists

I have recently installed PostGIS on my Mac (El Capitan 10.11.4, Postgres is version 9.5.1) using Homebrew, and I am following these …

postgresql postgis

GIS: PostGIS/PostgreSQL vs. MySql vs. SQL Server?

EDIT: I have been using Postgres with PostGIS for a few months now, and I am satisfied. I need to …

mysql postgresql gis geocoding postgis