Get Even More Visitors To Your Blog, Upgrade To A Business Listing >>

Blog Directory  >  Software Blogs  >  Open Source Blogs  >  Postgres OnLine Journal open-source Blog  > 

Postgres Online Journal Blog


postgresonline.com
Blog journal periodical dedicated to providing useful information for postgresql database users and potential users.
2024-03-05 17:43
The adoption of PostgreSQL is growing each year. Many people coming to PostgreSQL are often coming from other relational databases, with assumptions of how relational databases work. Alt… Read More
2023-09-03 04:13
We are pleased to provide binaries for file_textarray_fdw and odbc_fdw for PostgreSQL 16 Windows 64-bit. To use these, copy the files into your PostgreSQL 16 Windows 64-bit install folders i… Read More
2022-11-23 05:26
PostgreSQL keeps on adding new great stuff. It's hard to remember all the good stuff that has been added over the years. One of the neat ones from the past is the variadic Unnest function wh… Read More
2022-10-29 02:44
We are pleased to provide binaries for file_textarray_fdw and odbc_fdw for PostgreSQL 15 Windows 64-bit. To use these, copy the files into your PostgreSQL 15 Windows 64-bit install folders i… Read More
2021-10-12 02:18
One of the features we are most excited about in recently released PostgreSQL 14 is the introduction of Multirange types. In a nutshell Multirange types are sets of non-overlapping ranges. U… Read More
2021-10-12 02:15
We are pleased to provide binaries for file_textarray_fdw and odbc_fdw for PostgreSQL 14 Windows 64-bit. To use these, copy the files into your PostgreSQL 14 Windows 64-bit install folders i… Read More
2021-03-07 19:53
We are pleased to provide binaries for file_textarray_fdw and odbc_fdw for PostgreSQL 13 Windows 64-bit. To use these, copy the files into your PostgreSQL 13 Windows 64-bit install folders i… Read More
2019-10-23 23:55
We are pleased to provide binaries for file_textarray_fdw and odbc_fdw for PostgreSQL 12 Windows 64-bit. To use these, copy the files into your PostgreSQL 12 Windows 64-bit install folders i… Read More
2019-09-08 03:28
We are pleased to provide binaries for file_textarray_fdw and odbc_fdw for PostgreSQL 11 Windows 64-bit. To use these, copy the files into your PostgreSQL 11 Windows 64-bit install folders i… Read More
2019-04-01 13:31
Today is April 1st. Having no thoughts on Fools jokes for today, I dug up one of our old April fools, and it was pretty scary how the joke is just about true now. Yes SQL Server now really… Read More
2019-03-25 22:00
I gave a talk at PGConf US 2019 on some of the many ways you can load data into PostgreSQL using open source tools. This is similar to the talk I gave last year but with the addition of the… Read More
2019-02-11 08:31
We recently installed PostgreSQL 11 on an Ubuntu 18.04 using apt.postgresql.org. Many of our favorite extensions were already available via apt (postgis, ogr_fdw to name a few), but it didn… Read More
2018-12-10 00:18
PostGIS 2.5.1 was released on November 18th 2018 and I finished off packaging the PostGIS 2.5.1 windows builds and installers targeted for PostgreSQL EDB distribution this weekend and pushin… Read More
2018-06-14 07:12
Most of our use-cases for the built-in json support in PostgreSQL is not to implement schemaless design storage, but instead to remold data. Remolding can take the form of restructuring data… Read More
2018-06-09 07:02
Leo and I attended PostgresVision 2018 which ended a couple of days ago. We gave a talk on spatial extensions with main focus being PostGIS. Here are links to our slides PostgresVision2018_… Read More
2018-02-15 04:17
We've updated our binaries for PostgreSQL 10 windows, both 32 and 64-bit. The 64-bit should work fine with EnterpriseDb windows as well as BigSQL. Continue reading "FDWS for PostgreSQL Wind… Read More
2018-02-15 04:17
We've updated our binaries for PostgreSQL 10 windows, both 32 and 64-bit. The 64-bit should work fine with EnterpriseDb windows as well as BigSQL. Continue reading "FDWS for PostgreSQL Wind… Read More
2018-02-15 04:17
We've updated our binaries for PostgreSQL 10 windows, both 32 and 64-bit. The 64-bit should work fine with EnterpriseDb windows as well as BigSQL. Continue reading "FDWS for PostgreSQL Wind… Read More
2018-02-15 04:17
We've updated our binaries for PostgreSQL 10 windows, both 32 and 64-bit. The 64-bit should work fine with EnterpriseDb windows as well as BigSQL. Continue reading "FDWS for PostgreSQL Wind… Read More
2018-02-15 04:17
We've updated our binaries for PostgreSQL 10 windows, both 32 and 64-bit. The 64-bit should work fine with EnterpriseDb windows as well as BigSQL. Continue reading "FDWS for PostgreSQL Wind… Read More
2018-02-15 04:17
We've updated our binaries for PostgreSQL 10 windows, both 32 and 64-bit. The 64-bit should work fine with EnterpriseDb windows as well as BigSQL. Continue reading "FDWS for PostgreSQL Wind… Read More
2017-06-17 23:54
PostgreSQL has a feature called dollar-quoting, which allows you to include a body of text without escaping the single quotes. This feature has existed for quite some time. You've probabl… Read More
2016-11-23 05:39
A while ago when Foreign Data Wrappers in PostgreSQL was a fairly new thing, we talked about the ODBC_FDW foreign data wrapper. Since then, people have been asking us how to get the ODBC FDW… Read More
2016-10-10 22:26
For those folks on windows who want to do http gets and posts directly from your PostgreSQL server, we've made binaries for the http extension v1.1.2 release for PostgreSQL 9.6, 9.5, and 9.4… Read More
2016-10-10 22:26
For those folks on windows who want to do http gets and posts directly from your PostgreSQL server, we've made binaries for the http extension v1.1.2 release for PostgreSQL 9.6, 9.5, and 9.4… Read More
2016-06-04 03:59
Recently we found ourselves needing to purchase and download Zip+4 from the USPS. Zip+4 provides listing of mailable addresses in the US. We intend to use it for address validation. Each fil… Read More
2016-04-15 23:16
When David Page announced pgAdmin 4, I was really excited to try it out. I was impressed I could compile it so easily on windows. I had a few bumps, but not too bad. One of the reasons I'… Read More
2016-03-08 01:01
Leo and I attended the Paris OSGeo Code Sprint at Mozilla Foundation put together by Oslandia and funded by several companies. It was a great event. There was quite a bit of PostGIS related… Read More
2015-08-05 03:31
pgRouting 2.1 Beta release is out. Full details at https://lists.osgeo.org/pipermail/pgrouting-dev/2015-August/001569.html. pgRouting 2.1 works with PostGIS 2.1 and 2.2.0dev. Continue re… Read More
2015-03-01 23:35
One of the neat little features that arrived at PostgreSQL 9.4 is the WITH ORDINALITY ANSI-SQL construct. What this construct does is to tack an additional column called ordinality as an ad… Read More

Share the post

Postgres OnLine Journal

×

Subscribe to Postgres Online Journal

Get updates delivered right to your inbox!

Thank you for your subscription

×