2019-08-26 PostgreSQL – COALESCE and NULLIF
After the last week’s long post I decided that I needed some rest, so today I only have a short tip. . . . You’re welcome. CategoryEnglish, CategoryBlog, CategoryPostgreSQL . . .
2K - last updated 2019-09-05 21:33 UTC by Marcin Borkowski
2019-09-08 PostgreSQL and computing the number of days between two dates
A few days ago I had a very interesting bug. (Frankly, it’s nothing to be proud of, but it’s interesting . . . something. CategoryEnglish, CategoryBlog, CategoryPostgreSQL . . .
3K - last updated 2019-09-08 20:41 UTC by Marcin Borkowski
2019-10-28 PostgreSQL, jsonb each and cross joins
A few days ago I stumbled on a PostgreSQL query I didn't really understand. I asked a [[https://stackoverflow.com/q/58280136/1181665|question . . . really clever. CategoryEnglish, CategoryBlog, CategoryPostgreSQL . . .
3K - last updated 2019-10-28 17:00 UTC by Marcin Borkowski
2019-12-01 A simple trick with selecting rows created today
For today, I only have a short but useful (at least for me) trick. When I test some new feature involving . . . needs it one day. CategoryEnglish, CategoryBlog, CategoryPostgreSQL . . .
2K - last updated 2019-12-01 22:00 UTC by Marcin Borkowski
2020-02-15 PostgreSQL and null values in jsonb
Some time ago I was writing some PostreSQL queries involving columns of type jsonb. For some reason I . . . arrays, though. CategoryEnglish, CategoryBlog, CategoryPostgreSQL . . .
5K - last updated 2020-02-17 14:16 UTC by Marcin Borkowski
2020-02-24 Some psql tips
I have to admit that I’m more and more enamored by PostgreSQL. Since I often use its default client {{{psql}}}, . . . nightmarish). CategoryEnglish, CategoryBlog, CategoryPostgreSQL . . .
4K - last updated 2020-02-24 19:44 UTC by Marcin Borkowski
2020-03-02 PostgreSQL on Docker
Lately, I’ve been experimenting with PostgreSQL a lot. It is of course convenient to be able to set up . . . That’s good! CategoryEnglish, CategoryBlog, CategoryPostgreSQL . . .
3K - last updated 2020-03-02 21:10 UTC by Marcin Borkowski
2020-03-09 Using Org-mode as a PostgreSQL client
I often have to write more or less complex SQL queries. In case of the easy ones, there is no problem . . . CategoryBlog, CategoryEmacs, CategoryOrgMode, CategoryPostgreSQL . . .
5K - last updated 2020-03-09 08:12 UTC by Marcin Borkowski
2020-03-28 psql as a PostgreSQL teacher
A week ago, [[Comments on 2020-03-09 Using Org-mode as a PostgreSQL client|one of the commenters]] of . . . of tables etc. CategoryEnglish, CategoryBlog, CategoryPostgreSQL . . .
3K - last updated 2020-03-28 18:40 UTC by Marcin Borkowski
2020-09-27 Pretty printing SQL queries
I often work with SQL queries. Sometimes I write them myself, sometimes they are created by an ORM – . . . CategoryEnglish, CategoryBlog, CategoryEmacs, CategoryPostgreSQL . . .
2K - last updated 2020-09-27 19:38 UTC by mbork
2020-12-07 Temporary PostgreSQL tables
Today I have yet another small PostgreSQL tip. Sometimes you want just to experiment a bit, or maybe . . . it for today! CategoryEnglish, CategoryBlog, CategoryPostgreSQL . . .
1K - last updated 2020-12-07 22:02 UTC by mbork
2020-12-21 Pretty printing json and jsonb columns in PostgreSQL
And for today I have yet another short PostgreSQL tip. I use a database which has quite a few tables . . . for optimization. CategoryEnglish, CategoryBlog, CategoryPostgreSQL . . .
2K - last updated 2020-12-21 19:12 UTC by mbork
2021-09-13 A gotcha with PostgreSQL's jsonb type
As you may probably know, I am a big fan of PostgreSQL. That doesn't mean that it's always easy for me . . . this behavior... CategoryEnglish, CategoryBlog, CategoryPostgreSQL . . .
2K - last updated 2021-09-13 16:18 UTC by mbork
2021-11-29 Counting the number of columns in PostgreSQL
So I had this pretty big PostgreSQL table, and I wanted to know how many columns it had. Should be simple . . . smaller chunks. CategoryEnglish, CategoryBlog, CategoryPostgreSQL . . .
2K - last updated 2021-11-29 13:00 UTC by mbork
2022-01-29 Running a script before (and after) starting the psql prompt
And here I am again, with another PostgreSQL tip. Recently, I had a need of running {{{psql}}} interactively . . . fun querying! ;-) CategoryEnglish, CategoryBlog, CategoryPostgreSQL . . .
3K - last updated 2022-01-29 09:56 UTC by mbork
2022-02-28 A clever trick with psql copy and multiline select statements
For today, I have another PostgreSQL tip, which I admit is extremely niche, but useful nevertheless. . . . Happy copying! CategoryEnglish, CategoryBlog, CategoryPostgreSQL . . .
2K - last updated 2022-02-28 18:56 UTC by mbork
2022-09-12 Shifting dates or timestamps in PostgreSQL
For today I only have a short and simple PostgreSQL tip. Recently, for the purpose of testing, I needed . . . you next week! CategoryEnglish, CategoryBlog, CategoryPostgreSQL . . .
1K - last updated 2022-09-12 18:35 UTC by mbork
2022-09-26 Knex, PostgreSQL and bytea columns
Today I have yet another PostgreSQL-related tip. Some time ago I needed to put contents of some binary . . . Good luck coding! CategoryEnglish, CategoryBlog, CategoryPostgreSQL . . .
3K - last updated 2022-09-26 15:56 UTC by mbork
2023-05-29 A PostgreSQL query to set the serial counter
Some time ago I encountered an unpleasant bug I made in a certain PostgreSQL query. Assume that you have . . . Happy hacking! CategoryEnglish, CategoryBlog, CategoryPostgreSQL . . .
2K - last updated 2023-05-29 18:39 UTC by mbork
2024-03-11 More psql tricks
As I mentioned many times, I am a PostgreSQL fan. I [[2020-02-24 Some psql tips|wrote]] [[2020-03-28 . . . Happy querying! CategoryEnglish, CategoryBlog, CategoryPostgreSQL . . .
6K - last updated 2024-03-12 12:43 UTC by mbork
CategoryPostgreSQL
<list > . . .
1K - last updated 2019-09-05 21:33 UTC by Marcin Borkowski
21 pages found.