New package, p5-pgFormatter. From Kogule Ryo in PR pkg/56444.

A PostgreSQL SQL syntax beautifier that can work as a console program or as a
CGI.

This SQL formatter/beautifier supports keywords from SQL-92, SQL-99, SQL-2003,
SQL-2008, SQL-2011 and PostgreSQL specifics keywords. Works with any other
databases too.

Changes from the submitted version in the PR:

- p5 prefix for the package name
- clean up of github logic
- REPLACE_PERL
- updated distinfo with BLAKE2s

5 files changed, 64 insertions, 1 deletions

diff --git a/databases/Makefile b/databases/Makefile
index 4e286d3a07c..b5e349787de 100644
--- a/databases/Makefile
+++ b/databases/Makefile
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile,v 1.641 2021/10/08 10:23:43 adam Exp $
+# $NetBSD: Makefile,v 1.642 2021/11/06 15:09:26 bsiegert Exp $
 
 COMMENT=	Databases
 
@@ -241,6 +241,7 @@ SUBDIR+=	p5-Tie-DBI
 SUBDIR+=	p5-YAML-MLDBM
 SUBDIR+=	p5-gdbm
 SUBDIR+=	p5-perl-ldap
+SUBDIR+=	p5-pgFormatter
 SUBDIR+=	p5-postgresql
 SUBDIR+=	p5-qdbm
 SUBDIR+=	p5-sqlrelay
diff --git a/databases/p5-pgFormatter/DESCR b/databases/p5-pgFormatter/DESCR
new file mode 100644
index 00000000000..5005dc184c3
--- /dev/null
+++ b/databases/p5-pgFormatter/DESCR
@@ -0,0 +1,6 @@
+A PostgreSQL SQL syntax beautifier that can work as a console program or as a
+CGI.
+
+This SQL formatter/beautifier supports keywords from SQL-92, SQL-99, SQL-2003,
+SQL-2008, SQL-2011 and PostgreSQL specifics keywords. Works with any other
+databases too.
diff --git a/databases/p5-pgFormatter/Makefile b/databases/p5-pgFormatter/Makefile
new file mode 100644
index 00000000000..d8e149d40e8
--- /dev/null
+++ b/databases/p5-pgFormatter/Makefile
@@ -0,0 +1,37 @@
+# $NetBSD: Makefile,v 1.1 2021/11/06 15:09:26 bsiegert Exp $
+
+GITHUB_PROJECT=	pgFormatter
+GITHUB_TAG=	v${PKGVERSION_NOREV}
+DISTNAME=	pgFormatter-5.1
+PKGNAME=	p5-${DISTNAME}
+CATEGORIES=	databases textproc perl5
+MASTER_SITES=	${MASTER_SITE_GITHUB:=darold/}
+
+MAINTAINER=	pkgsrc-users@NetBSD.org
+HOMEPAGE=	https://github.com/darold/pgFormatter/
+COMMENT=	PostgreSQL SQL syntax beautifier
+LICENSE=	postgresql-license
+
+PERL5_PACKLIST=	auto/pgFormatter/.packlist
+USE_LANGUAGES=	# none
+
+DOCDIR=		${PREFIX}/share/doc/pgFormatter
+
+INSTALLATION_DIRS+=		${DOCDIR}
+
+SUBST_CLASSES+=			fix-paths
+SUBST_STAGE.fix-paths=		pre-configure
+SUBST_MESSAGE.fix-paths=	Fixing absolute paths.
+SUBST_FILES.fix-paths=		doc/pg_format.pod
+SUBST_SED.fix-paths=		-e 's,doc/pg_format.conf.sample,${DOCDIR}/pg_format.conf.sample,g'
+
+REPLACE_PERL=	pg_format
+
+post-install:
+.for doc in ChangeLog LICENSE README doc/pg_format.conf.sample
+	${INSTALL_DATA} ${WRKSRC}/${doc} ${DESTDIR}${DOCDIR}
+.endfor
+
+
+.include "../../lang/perl5/module.mk"
+.include "../../mk/bsd.pkg.mk"
diff --git a/databases/p5-pgFormatter/PLIST b/databases/p5-pgFormatter/PLIST
new file mode 100644
index 00000000000..1e830bbade1
--- /dev/null
+++ b/databases/p5-pgFormatter/PLIST
@@ -0,0 +1,14 @@
+@comment $NetBSD: PLIST,v 1.1 2021/11/06 15:09:26 bsiegert Exp $
+${PERL5_SUB_INSTALLVENDORARCH}/auto/pgFormatter/.packlist
+${PERL5_SUB_INSTALLVENDORLIB}/pgFormatter/Beautify.pm
+${PERL5_SUB_INSTALLVENDORLIB}/pgFormatter/CGI.pm
+${PERL5_SUB_INSTALLVENDORLIB}/pgFormatter/CLI.pm
+${PERL5_SUB_INSTALLVENDORBIN}/pg_format
+${PERL5_SUB_INSTALLVENDORMAN1DIR}/pg_format.1
+${PERL5_SUB_INSTALLVENDORMAN3DIR}/pgFormatter::Beautify.3
+${PERL5_SUB_INSTALLVENDORMAN3DIR}/pgFormatter::CGI.3
+${PERL5_SUB_INSTALLVENDORMAN3DIR}/pgFormatter::CLI.3
+share/doc/pgFormatter/ChangeLog
+share/doc/pgFormatter/LICENSE
+share/doc/pgFormatter/README
+share/doc/pgFormatter/pg_format.conf.sample
diff --git a/databases/p5-pgFormatter/distinfo b/databases/p5-pgFormatter/distinfo
new file mode 100644
index 00000000000..b47e178c736
--- /dev/null
+++ b/databases/p5-pgFormatter/distinfo
@@ -0,0 +1,5 @@
+$NetBSD: distinfo,v 1.1 2021/11/06 15:09:26 bsiegert Exp $
+
+BLAKE2s (pgFormatter-5.1.tar.gz) = 525812b0d47b1127c67fd377dba7bafe8f30455e443487e8b2985228fa53253a
+SHA512 (pgFormatter-5.1.tar.gz) = 86afb0e77a000145bdcfbd3d5f91c59dc8de3676b4e764a4b86147a52fd7787681b33f4e23a4e0eb9b15e9a24d5b60eb01c90574f59ff5cab2f33489c5f2e91b
+Size (pgFormatter-5.1.tar.gz) = 1314702 bytes