Tags » PostgreSQL

PostgreSQL - List All Tables and Describe Tables

Connect to the database:
psql [-U username] [-h hostname] database-name

To list all databases, type either one of the following:
\l
\list

To list tables in a current database, type: 14 more words

DataBase

Connecting to postgres using domain sockets and libpq

We recently started using Goose to run our migrations, and I wanted to connect to the Postgres instance on a local machine using a domain socket. 155 more words

Golang

Bucardo 5 Cascaded Slave Replication

When I read new release of Bucardo 5 with capability of asynchronous multi-master replication, I was eagered to wet my foot before swimming. Not really about multi-master features, just to implement simple master-slave-cascaded_slave replication, as I have done with Slony. 306 more words

PostgreSQL

How to make a great-circle linestring

The postGIS GEOGRAPHY type connects two points on the Earth’s surface by the shortest route (the great-circle line). Unfortunately when displayed in Quantum GIS, this will appear as the shortest route between two points in map-space (actually a… 47 more words

PostGIS

Install and setup PostgreSQL for Django

1. Deactivate the virtualenv if there is.

pyenv deactivate

2. Install the required libraries.

sudo apt-get install libpq-dev python-dev

3. Install PostgreSQL.

sudo apt-get install postgresql postgresql-contrib 236 more words
Ubuntu

Django - Schedule django-admin command using django-chronograph

Previously we talked about setting up some custom command in a Django project.

I would like to run the custom command in a regular interval. 560 more words

Linux

Integrating jOOQ with PostgreSQL: Partitioning

Introduction

jOOQ is a great framework when you want to work with SQL in Java without having too much ORM in your way. At the same time, it can be integrated into many environments as it is offering you support for many database-specific features. 1,395 more words

Sql