-
Describe table is a commonly used query in MySQL. In PostreSQL there isn’t a direct equivalent of this command. In PostgreSQL command line (pgsql) you can use: Some cloud provider use a special build or they don’t directly provide pg interface, therefore you can’t use \d \dt commands. You might need an SQL alternative to…
-
How to show tables in PostgreSQL is a common question for beginners. In this article we will discuss showing tables in PostgreSQL. In PostgreSQL all information about DB objects stored under information_schema. You can use information_schema.tables table to list and show tables. A simple query to list all tables and schemas: If you want to…
-
Hello, this is a test purpose article about PostgreSQL for beginners. PostgreSQL is a powerful, open-source relational database management system (RDBMS). It is a popular choice for a wide range of applications, including web applications, data warehousing, and big data analytics. PostgreSQL is known for its reliability, scalability, and flexibility. This blog article is designed…