Skip to content

=$
|

  • Why upgrade PG?
  • explain.D.C
  • paste.D.C
  • Waiting for …
    • … PostgreSQL 16
    • … PostgreSQL 15
    • … PostgreSQL 14
    • … PostgreSQL 13
    • … PostgreSQL 12
    • … PostgreSQL 11
    • … PostgreSQL 10
    • … PostgreSQL 9.6
    • … PostgreSQL 9.5
    • … PostgreSQL 9.4
    • … PostgreSQL 9.3
    • … PostgreSQL 9.2
    • … PostgreSQL 9.1
    • … PostgreSQL 9.0
    • … PostgreSQL 8.5
    • … PostgreSQL 8.4
  • Projects
  • Contact

Tag: pg_format

New SQL pretty printer – based on parsing, and not regexps

For a long time I was looking for SQL pretty printer.

Some queries that I had to deal with, over the years, were just insane to read, like this:

Continue reading New SQL pretty printer – based on parsing, and not regexps

Posted on 2022-08-31|Tags explain.depesz.com, formatting, libpg_query, paste.depesz.com, pg-sql-prettyformat, pg_format, pg_query, postgresql, pretty|4 Comments on New SQL pretty printer – based on parsing, and not regexps

Search

Follow me

  • Comments RSS
  • Posts RSS

Popular Posts

  • Can you use fzf for psql history? 314 views | 0 comments
  • CHAR(x) vs. VARCHAR(x) vs. VARCHAR vs. TEXT – UPDATED 2010-03-03 233 views | 0 comments
  • Explaining the unexplainable – part 3 206 views | 0 comments
  • Explaining the unexplainable – part 2 191 views | 0 comments
  • “ERROR: operator does not exist: integer = text” how to fix it? 145 views | 0 comments
  • Waiting for PostgreSQL 11 – Fast ALTER TABLE ADD COLUMN with a non-NULL default 140 views | 0 comments
  • How to run short ALTER TABLE without long locking concurrent queries 103 views | 0 comments
  • Waiting for PostgreSQL 16 – Invent random_normal() to provide normally-distributed random numbers. 99 views | 0 comments
  • How much RAM is PostgreSQL using? 97 views | 0 comments
  • how to insert data to database – as fast as possible 95 views | 0 comments

PostgreSQL

  • Documentation
  • Explain Analyze analyzer
  • IRC help channel
  • Mailing Lists search
  • PG Planet
  • PostgreSQL Home Page

About me

  • CPAN
  • GitLab
  • Linked In
  • Why upgrade PG?
  • explain.D.C
  • paste.D.C
  • Waiting for …
    • … PostgreSQL 16
    • … PostgreSQL 15
    • … PostgreSQL 14
    • … PostgreSQL 13
    • … PostgreSQL 12
    • … PostgreSQL 11
    • … PostgreSQL 10
    • … PostgreSQL 9.6
    • … PostgreSQL 9.5
    • … PostgreSQL 9.4
    • … PostgreSQL 9.3
    • … PostgreSQL 9.2
    • … PostgreSQL 9.1
    • … PostgreSQL 9.0
    • … PostgreSQL 8.5
    • … PostgreSQL 8.4
  • Projects
  • Contact