--- title: "#psql articles | Hashnode" description: "Explore 29 articles tagged #psql on Hashnode. Tutorials, guides, and how-tos from the community." url: "https://hashnode.com/tag/psql" --- Tag # #psql 29 posts · 13 followers [Aira Franco](https://hashnode.com/@Aira) · [Mar 30](https://hashnode.com/posts/robust-etl-pipeline-learning-log/69ca18ef5282e6ac9c5ad288) ### [Engineering a Robust ETL Pipeline for Messy Product Data](https://dataengineeringlearning.hashnode.dev/robust-etl-pipeline-learning-log?utm_source=hashnode&utm_medium=feed) Built a DataOps ETL pipeline that cleans messy CSV data, validates it, and loads trusted/rejected records into PostgreSQL for reliable analytics. 3 min read · [dataengineeringlearning.hashnode.dev](https://dataengineeringlearning.hashnode.dev/robust-etl-pipeline-learning-log?utm_source=hashnode&utm_medium=feed) [Mandeep Singh](https://hashnode.com/@mandeepsingh) · [Mar 12](https://hashnode.com/posts/step-by-step-guide-create-postgresql-database-user-and-grant-privileges-on-ubuntu/69b2adbc31303b597ced5c61) ### [Step-by-Step Guide: Create PostgreSQL Database, User, and Grant Privileges on Ubuntu](https://mandeepsingh.hashnode.dev/step-by-step-guide-create-postgresql-database-user-and-grant-privileges-on-ubuntu?utm_source=hashnode&utm_medium=feed) Here is the correct way to create a PostgreSQL database, user, and give full permissions on Ubuntu. 1️⃣ Login to PostgreSQL sudo -i -u postgres psql 2️⃣ Create Database CREATE DATABASE "the-ai-shift 2 min read · [mandeepsingh.hashnode.dev](https://mandeepsingh.hashnode.dev/step-by-step-guide-create-postgresql-database-user-and-grant-privileges-on-ubuntu?utm_source=hashnode&utm_medium=feed) [Deepansh Gangwar](https://hashnode.com/@mr-deepansh) · [Feb 28](https://hashnode.com/posts/postgresql-complete-beginner-developer-cheatsheet-in-depth/69a2d85e0728161017ddad49) ### [PostgreSQL Complete Beginner → Developer Cheatsheet (In-Depth)](https://blog-deepansh.hashnode.dev/postgresql-complete-beginner-developer-cheatsheet-in-depth?utm_source=hashnode&utm_medium=feed) Learning postgres Beginner to advanced lavel. posgressql Installation on window 11/pro. Relational Databases, structured query language SQL Cammands 3 min read · [blog-deepansh.hashnode.dev](https://blog-deepansh.hashnode.dev/postgresql-complete-beginner-developer-cheatsheet-in-depth?utm_source=hashnode&utm_medium=feed) [Krishna Sharma](https://hashnode.com/@Krishna1911) · [Feb 4](https://hashnode.com/posts/essential-psql-commands-for-postgresql/69831bc117b0ac9e5cfdd052) ### [Essential psql Commands for PostgreSQL](https://kris-learn.hashnode.dev/essential-psql-commands-for-postgresql?utm_source=hashnode&utm_medium=feed) psql is the interactive terminal client for PostgreSQL. It lets you connect to databases, run SQL queries, and use powerful meta commands for database management. Connecting to PostgreSQL (Note : here the user is named as “potatoes“, and DB as “mypo... 2 min read · [kris-learn.hashnode.dev](https://kris-learn.hashnode.dev/essential-psql-commands-for-postgresql?utm_source=hashnode&utm_medium=feed) [Lakshay Gupta](https://hashnode.com/@voidness) · [Jan 19](https://hashnode.com/posts/partitioning-a-table-in-postgresql-pros-and-cons-explained/696e31f56532492debd345fc) ### [Partitioning a Table in PostgreSQL - Pros and Cons Explained](https://blog.lakshyabuilds.com/partitioning-a-table-in-postgresql-pros-and-cons-explained?utm_source=hashnode&utm_medium=feed) Partition is a very sensitive topic for some people. Like the 1947 India-Pak partition which lead to so many families getting devasted. But some partitions are not that bad. For e.g., partitioning your relational table. This blog talks about the good... 6 min read · [blog.lakshyabuilds.com](https://blog.lakshyabuilds.com/partitioning-a-table-in-postgresql-pros-and-cons-explained?utm_source=hashnode&utm_medium=feed) [Lakshay Gupta](https://hashnode.com/@voidness) · [Dec 31, 2025](https://hashnode.com/posts/read-this-before-creating-your-next-index-in-psql/6954732586c4c7189f491aca) ### [Read this Before Creating Your Next Index in PSQL](https://blog.lakshyabuilds.com/read-this-before-creating-your-next-index-in-psql?utm_source=hashnode&utm_medium=feed) If you are a beginner in your developer journey tasked with optimizing a database query, you must have read about applying indexes. But not all indexes bring performance gains. Some can even degrade it. Read this blog before your create your next ind... 8 min read · [blog.lakshyabuilds.com](https://blog.lakshyabuilds.com/read-this-before-creating-your-next-index-in-psql?utm_source=hashnode&utm_medium=feed) [Lakshay Gupta](https://hashnode.com/@voidness) · [Dec 22, 2025](https://hashnode.com/posts/mastering-psql-7-essential-commands-for-database-efficiency/69499a5aef12b8da5ad8679e) ### [Mastering PSQL: 7 Essential Commands for Database Efficiency](https://blog.lakshyabuilds.com/mastering-psql-7-essential-commands-for-database-efficiency?utm_source=hashnode&utm_medium=feed) Postgres or PSQL Database is a type of relational database widely used across the industry. Various big tech corporations across the globe use it to store mission-critical data. The language it understands is SQL. People are already familiar with man... 5 min read · [blog.lakshyabuilds.com](https://blog.lakshyabuilds.com/mastering-psql-7-essential-commands-for-database-efficiency?utm_source=hashnode&utm_medium=feed) [Cristhian Cano Bogado](https://hashnode.com/@paraguayandev) · [Nov 11, 2025](https://hashnode.com/posts/utiliza-codigo-javascript-desde-plsql-con-apexjavascript/69136f9d0d9908e2a01c2b05) ### [Utiliza código JAVASCRIPT desde PL/SQL con APEX\_JAVASCRIPT](https://paraguayandev.hashnode.dev/utiliza-codigo-javascript-desde-plsql-con-apexjavascript?utm_source=hashnode&utm_medium=feed) Oracle APEX combina lo mejor del desarrollo declarativo con el poder del código PL/SQL, y si ya viste cómo podemos aplicar estilos dinámicos con APEX\_CSS, ahora vamos un paso más allá: inyectar y ejecutar código JavaScript directamente desde PL/SQL. ... 3 min read · [paraguayandev.hashnode.dev](https://paraguayandev.hashnode.dev/utiliza-codigo-javascript-desde-plsql-con-apexjavascript?utm_source=hashnode&utm_medium=feed) [Dhanush Gowda](https://hashnode.com/@dhanushks26) · [Sep 14, 2025](https://hashnode.com/posts/postgresql-architecture/68c709cc07cc605eac2bf9fe) ### [PostgreSQL Architecture](https://dhanushks.hashnode.dev/postgresql-architecture?utm_source=hashnode&utm_medium=feed) Admin Guide 20 min read · [dhanushks.hashnode.dev](https://dhanushks.hashnode.dev/postgresql-architecture?utm_source=hashnode&utm_medium=feed) [Murali Krishna Appari](https://hashnode.com/@Murali789) · [Aug 18, 2025](https://hashnode.com/posts/safely-deleting-postgresql-roles-and-reassigning-ownership-interactive-script/68a3072b7b122ee7dadeeab1) ### [Safely Deleting PostgreSQL Roles and Reassigning Ownership (Interactive Script)](https://muralidevops.hashnode.dev/safely-deleting-postgresql-roles-and-reassigning-ownership-interactive-script?utm_source=hashnode&utm_medium=feed) Managing PostgreSQL roles securely is crucial, especially when decommissioning application users or consolidating database accounts. Simply dropping a role can fail if it owns objects, databases, or has privileges scattered across multiple databases.... 5 min read · [muralidevops.hashnode.dev](https://muralidevops.hashnode.dev/safely-deleting-postgresql-roles-and-reassigning-ownership-interactive-script?utm_source=hashnode&utm_medium=feed)