Tags » PostgreSQL

Creating titles from text (SQL)

Task: get title (or excerpt) from given text (body)

left(body, 29) ||
COALESCE( substring( substr( body, 30 ) from '(.+?)(\,| )' ), '' ) as title,
33 more words


MicroOLAP Database Designer for PostgreSQL 1.10.6 available

The MicroOLAP team is proud to introduce Database Designer for PostgreSQL, an comprehensive CASE tool which works natively under Windows OS family and Linux under Wine/WineHQ allowing you to… 168 more words


User rights management in PostgreSQL compared to MySql and Oracle

PostgreSQL has slightly different approach of user rights management comparing to MySql and Oracle. In this article, we will cover very basic concepts how to setup users for your application / maintenance people. 654 more words


PSA: The ODBC sslmode parameter for Redshift is case sensitive

When connecting to Redshift through an ODBC connection be aware that the value of the sslmode parameter is case sensitive and needs to be lower case. 35 more words


Manage Your PostgreSQL Extensions With Pgbundle

One of Postgres’ most powerful features is its extensibility. Although Postgres offers a large number of data types, functions, operators, and aggregates, sometimes you may still want more. 934 more words

How to dump postgresql functions

It can be useful to dump schemas functions.
For example, when you have multiple schemas in your database, if a public function refers to a particular schemas table, you’ll not be able to restore it with a simple dump/restore. 184 more words


Using galleries (or other accesses to ORDER BY FIELD() ) in WordPress over PostgreSQL using PG4WP driver

Galleries in WordPress 3.6 does not show in a setup over a PostgreSQL database using PG4WP driver.

The gallery functionality makes use of ORDER BY FIELD() MySQL command that is not handled by the PG4WP 1.3.1 driver. 160 more words

IT Stuff