Top "Postgresql-9.2" questions

for PostgreSQL questions specific to version 9.2.

Permission denied for relation

I tried to run simple sql command: select * from site_adzone; and I got this error ERROR: permission denied for …

postgresql privileges postgresql-9.2 grant
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

I am trying to open a program for the first time on Windows XP Pro that uses PostgreSQL 9. I'm getting …

odbc installation postgresql-9.2
Export and import table dump (.sql) using pgAdmin

I have pgAdmin version 1.16.1 So, for exporting table dumm I do: Right click on table, then in menu click on …

postgresql postgresql-9.2 pgadmin
Postgres DB Size Command

What is the command to find the size of all the databases? I am able to find the size of …

sql postgresql postgresql-9.2
PostgreSQL query to list all table names?

Is there any query available to list all tables in my Postgres DB. I tried out one query like: SELECT …

postgresql postgresql-9.2
Postgresql 9.2 pg_dump version mismatch

I am trying to dump a Postgresql database using the pg_dump tool. $ pg_dump books > books.out How …

postgresql backup pg-dump postgresql-9.2
How do I query using fields inside the new PostgreSQL JSON datatype?

I am looking for some docs and/or examples for the new JSON functions in PostgreSQL 9.2. Specifically, given a series …

sql json postgresql postgresql-9.2 postgresql-9.3
Connecting PostgreSQL 9.2.1 with Hibernate

I have a blank Spring MVC project, and I've installed Hibernate and the PostgreSQL drivers using Maven. I'm running short …

java hibernate postgresql postgresql-9.2
Postgresql - unable to drop database because of some auto connections to DB

Whenever I try to drop database I get: ERROR: database "pilot" is being accessed by other users DETAIL: There is 1 …

postgresql postgresql-9.2 postgresql-9.5
Socket File "/var/pgsql_socket/.s.PGSQL.5432" Missing In Mountain Lion (OS X Server)

I just upgraded my MacMini Server from Lion Server to Mountain Lion using OS X Server. I am having the …

postgresql osx-mountain-lion postgresql-9.2 osx-server