CYBERTEC PostgreSQL Logo

Category: How To

Get the Newest PostgreSQL Info, Tips & Tricks
Here you can find all blog posts about the Category: How To. You can go back to all blog posts or take a look into our other categories & tags.

Inheritance - One more reason to love PostgreSQL

by Hans-Jürgen Schönig | 07.2016
The PostgreSQL feature "inheritance" works like a charm. You ask why? Well, here are the details we really like about it.

PostgreSQL exclusion constraints: Beyond UNIQUE

by Hans-Jürgen Schönig | 07.2016
UPDATED AUGUST 2023: A couple of years ago, PostgreSQL introduced so called “exclusion constraints”, which are defined with the EXCLUDE […]

BRIN indexes: Correlation, correlation, correlation

by Hans-Jürgen Schönig | 06.2016
BRIN indexes have been introduced in PostgreSQL 9.5. While BRIN indexes are definitely a win, people tend to exaggerate and use them far too frequently.

Watch command - how to watch a PostgreSQL database

by Hans-Jürgen Schönig | 06.2016
How to use the watch command: allows you to watch the program output change over time. It is therefore a perfect tool to track down errors.

Beating Uber with a PostgreSQL prototype

by Hans-Jürgen Schönig | 05.2016
How to beat the latency of Uber's geo-fencing query by just using nice PostgreSQL code and 30 minutes of programming time.

Migrating from Oracle: One word about pg_type

by Hans-Jürgen Schönig | 04.2016
Here is some pg_type related trickery, which might be entertaining. A workaround for porting the pg_type table from Oracle to PostgreSQL.

Registering PostgreSQL as a service on Windows with pg_ctl

by Hans-Jürgen Schönig | 04.2016
If you happen to run Windows, pg_ctl provides a nice way to register a PostgreSQL service. We show you how to do it right.

pg_service.conf: The forgotten config file

by Hans-Jürgen Schönig | 02.2016
Configure services in a config file: pg_service.conf, and address them without having to worry about host, port, user and so on.

Permissions: A little trickery

by Hans-Jürgen Schönig | 12.2015
Learn how to use the INHERIT keyword in PostgreSQL, which allows a role to inherit permissions from another role. There is a catch, however.

Producing LaTeX output

by Hans-Jürgen Schönig | 12.2015
By coincidence I noticed that psql can produce perfect LaTeX code. How cool is that? We show you how to do it, with examples.
1 … 27 28 29 30 31 … 35
CYBERTEC Logo white
CYBERTEC PostgreSQL International GmbH
Römerstraße 19
2752 Wöllersdorf
Austria

+43 (0) 2622 93022-0
office@cybertec.at

STAY TUNED WITH OUR NEWSLETTER
Get the newest PostgreSQL Info & Tools


    This site is protected by reCAPTCHA and the Google Privacy Policy & Terms of Service apply.

    ©
    2024
    CYBERTEC PostgreSQL International GmbH
    phone-handsetmagnifiercrosscross-circle
    linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram