# Home

> Expert PostgreSQL support & consulting since 1997. 24/7/365 managed services, migrations, performance tuning & extended support. Enterprise-grade solutions.

## Pages
- [Services](https://www.commandprompt.com/services/): Full-stack PostgreSQL & open source consulting: database optimization, Linux administration, Python/Ruby development, Ansible automation & 24/7 support services.
- [Full Stack Offerings](https://www.commandprompt.com/services/fullstack/): Command Prompt Full Stack Offerings
- [Training](https://www.commandprompt.com/services/training/): Command Prompt On-Demand Training for PostgreSQL
- [Nutanix Products](https://www.commandprompt.com/services/nutanix-products/)
- [Database Migration](https://www.commandprompt.com/services/database-migration/)
- [Advanced Monitoring Solutions](https://www.commandprompt.com/services/advanced-monitoring-solutions/)
- [About](https://www.commandprompt.com/about/): North America's oldest PostgreSQL & open source provider since 1997. Full-stack expertise: database, Linux, Python, Ruby, Ansible. Serving Fortune 500 companies.
- [Support Options](https://www.commandprompt.com/about/support-options/): Postgres and Open Source Support form the Leader in the Industry
- [Careers](https://www.commandprompt.com/about/careers/): Command Prompt Inc. careers
- [Database and Systems Administrator](https://www.commandprompt.com/about/careers/database-and-systems-administrator/)
- [Database and Systems Administrator (No-US)](https://www.commandprompt.com/about/careers/database-and-systems-administrator-no-us/)
- [Project Management Assistant](https://www.commandprompt.com/about/careers/project-management-assistant/)
- [Sr. Inside Sales Representative](https://www.commandprompt.com/about/careers/sr-inside-sales-representative/)
- [Intrepidus Vita](https://www.commandprompt.com/about/intrepidusvita/)
- [Policies](https://www.commandprompt.com/about/policies/)
- [Code of Conduct](https://www.commandprompt.com/about/code-of-conduct/): code of conduct
- [PgConf](https://www.commandprompt.com/about/pgconf/)
- [Support](https://www.commandprompt.com/support/)
- [Support for EOL versions of Postgres](https://www.commandprompt.com/support/support-for-eol-versions-of-postgres/)
- [PostgreSQL extended support for cloud](https://www.commandprompt.com/support/support-for-eol-versions-of-postgres/postgres-support-extended-for-cloud/): Postgres Support plus EOL for CLoud
- [Postgres Support](https://www.commandprompt.com/support/postgres-support/): Postgres Support from North America's oldest Postgres Company
- [PostgreSQL Feature Matrix](https://www.commandprompt.com/support/postgresql-feature-matrix/)
- [Terms of Use](https://www.commandprompt.com/terms-of-use/): terms of use
- [Privacy Policy](https://www.commandprompt.com/privacy-policy/)
- [U.S. States Privacy Notice](https://www.commandprompt.com/privacy-policy/us-states-privacy-notice/)
- [Products](https://www.commandprompt.com/products/): PostgreSQL products & open source tools: PgManage GUI admin, PgLTS extended support, pgBackRest backup, pglogical replication. Enterprise-ready solutions.
- [PgLTS: The Postgres for the Enterprise](https://www.commandprompt.com/products/pglts/): PostgreSQL Long Term Support
- [Audax Data Manager](https://www.commandprompt.com/products/audax-data-manager/)
- [Performance Audit](https://www.commandprompt.com/products/performance-audit/)
- [Audit & Tune](https://www.commandprompt.com/products/audit-tune/)
- [Cloud Migration Assessment](https://www.commandprompt.com/products/cloud-migration-assessment/)

## Podcasts
- [More Than A Refresh](https://www.commandprompt.com/about/more-than-a-refresh/)

## Blog
- [PgManage 1.4 – SQL Server, Fast Database Navigation, Spreadsheet‑like Data Grids & More](https://www.commandprompt.com/blog/pgmanage-14-sql-server-fast-database-navigation-spreadsheet-like-data-grids-more/): PgManage now supports Microsoft SQL Server and has numerous UI improvements and features intended make your daily database work more efficient.
- [Cost Optimization for PostgreSQL: Practical Tips for Technical Teams](https://www.commandprompt.com/blog/cost-optimization-for-postgresql-practical-tips-for-technical-teams/): In a previous post, we explored the importance of right-sizing PostgreSQL environments and avoiding the trap of overprovisioning for peak demand. While archite…
- [PostgreSQL 18: Revolutionary Performance Boost Now Available](https://www.commandprompt.com/blog/postgresql-18-revolutionary-performance-boost-now-available/): PostgreSQL 18 delivers revolutionary 3x I/O performance improvements, seamless upgrades with preserved statistics, OAuth 2.0 support, and virtual generated columns. Feature guide and upgrade recommendations.
- [Why Growing Teams Are Moving from Aurora to RDS or EC2: Cost and Control Considerations on AWS](https://www.commandprompt.com/blog/why-growing-teams-are-moving-from-aurora-to-rds-or-ec2-cost-and-control-considerations-on-aws/): Why Growing Teams Are Moving from Aurora to RDS or EC2: Cost and Control Considerations for PostgreSQL on AWS
- [PgManage 1.3.1: Enterprise Edition Released](https://www.commandprompt.com/blog/pgmanage-131-enterprise-edition-released/): PgManage 1.3.1 is now available with fixes across PostgreSQL, Oracle, MariaDB, and SQLite3, plus updated dependencies and UI refinements. Learn what’s new and explore PgManage Enterprise Edition with remote access, multi-user support, and OAuth2 integration.
- [Lessons from the CISA and USCG Joint Advisory: What “No Breach” Still Reveals](https://www.commandprompt.com/blog/lessons-from-the-cisa-and-uscg-joint-advisory-what-no-breach-still-reveals/): CISA & USCG’s AA25-212A advisory highlights systemic security gaps. No breach doesn’t mean no risk—resilience requires proactive hardening.
- [Upgrading PostgreSQL and Citus for Enhanced Database Functionality](https://www.commandprompt.com/blog/upgrading-postgresql-and-citus-for-enhanced-database-functionality/): Learn how PostgreSQL and Citus were upgraded from 11/8.3 to 15.5/12.1 with improved performance and scalability in this real-world case study.
- [Lessons From The Road: More Intention, Less Autopilot](https://www.commandprompt.com/blog/lessons-from-the-road-more-intention-less-autopilot/): How much of our time is spent on autopilot?Most people can agree that our internal autopilot systems enable us to be efficient and effective. It allows us to d…
- [Service Monitoring via Hazard Analysis White Paper](https://www.commandprompt.com/blog/service-monitoring-via-hazard-analysis-white-paper/): Apply hazard analysis and Critical Control Points (CCPs) to IT monitoring. Improve service reliability, reduce costs, and detect issues before they impact users.
- [Critical Security Alert: Immediate Action Required for Self-Hosted SharePoint Servers (CVE-2025-53770)](https://www.commandprompt.com/blog/critical-security-alert-immediate-action-required-for-self-hosted-sharepoint-servers-cve-2025-53770/): A critical, newly disclosed, and actively exploited vulnerability, CVE-2025-53770, affects all self-hosted / on-premises Microsoft SharePoint Server versions. …

## Education
- [How to Create, Update and Drop Tables in a PostgreSQL Docker Container](https://www.commandprompt.com/education/how-to-create-update-and-drop-tables-in-a-postgresql-docker-container/): To create, update and drop tables in PostgreSQL container, build and run PostgreSQL container and connect with Database Server. Then, perform these operations.
- [What’s the Difference Between HAVING Clause and WHERE Clause in PostgreSQL?](https://www.commandprompt.com/education/difference-between-having-where-clause-postgresql/): In PostgreSQL, the WHERE clause filters the data of each row and then groups the data while the HAVING clause filters the grouped data.
- [PostgreSQL Cheat Sheet - Basic Commands](https://www.commandprompt.com/education/postgresql-cheat-sheet-databases-schemas-tables-users/): This blog presented a cheat sheet that assists us in working with the Postgres databases, schemas, tables, and users/roles, efficiently.
- [PostgreSQL Pattern Matching: LIKE VS NOT LIKE VS ILIKE](https://www.commandprompt.com/education/postgresql-pattern-matching-like-vs-not-like-vs-ilike/): The LIKE operator matches the search expression with the specified pattern and retrieves true if the match is found. The NOT LIKE operator negates the results …
- [How to Connect PostgreSQL to Java Using JDBC](https://www.commandprompt.com/education/connect-postgresql-java-jdbc/): To connect PostgreSQL to Java via JDBC, integrate Postgres JDBC Driver with Java, and establish a new connection. After this, you can execute PostgreSQL Querie…
- [PostgreSQL LENGTH() Function With Practical Examples](https://www.commandprompt.com/education/postgresql-length-function-examples/): The Postgres LENGTH() function accepts a string as an argument and calculates the total number of characters in that particular string.
- [How to Show Databases in PostgreSQL](https://www.commandprompt.com/education/show-databases-postgresql/): In PostgreSQL, the “\l” command and “pg_databases” catalog are used to show the list of databases. Use the “\l+” command to show databases with more details.
- [How to Create a Database in PostgreSQL](https://www.commandprompt.com/education/how-to-create-a-database-in-postgresql/): A Postgres database can be created using “CREATE DATABASE” or “createdb” commands. The difference is that the “createdb” can be executed from the command promp…
- [How to Install PostgreSQL (psql) on Arch Linux](https://www.commandprompt.com/education/install-postgresql-psql-arch-linux/): To install PostgreSQL on the Arch system, use the default Pacman package manager tool. More specifically, using the “sudo pacman -S postgresql” command.
- [How to Use LIMIT Clause in PostgreSQL](https://www.commandprompt.com/education/how-to-use-limit-clause-in-postgresql/): In PostgreSQL, the LIMIT clause and OFFSET clause allow us to retrieve only a subset of data returned/generated by the SELECT query.

## More
- [Full Markdown export of this site](https://www-staging.commandprompt.com/llms-full.txt)
- [Sitemap](https://www-staging.commandprompt.com/sitemap.xml)