Skip to content

Tag Archives: postgreSQL-managing-table

In this article will discuss we will discuss the process of exporting a PostgreSQL Table to a CSV file. Here we will see how to… Read More
PostgreSQL is a type of relational database (RDBMS) similar to MySQL. Relational Database stores data in the form of a table in which each row… Read More
PostgreSQL uses record type variables which simply act as placeholders for rows of a result set, similar to a row type variable. However, unlike row… Read More
PostgreSQL uses the Row type variables to store a whole row of a result set returned by the select into statement. Declaration : We can… Read More
This article will explore the process to create new tables in the PostgreSQL database using Python. Steps for creating PostgreSQL tables in Python To create… Read More
In this article we will look into the process of inserting data into a PostgreSQL Table using Python. To do so follow the below steps:… Read More
This article explores the process of creating table in The PostgreSQL database using Python. Prerequisites: psycopg2 module sample database Creating a Table: To create a… Read More
In PostgreSQL, the select into statement to select data from the database and assign it to a variable. Syntax: select select_list into variable_name from table_expression;… Read More
In this article, we will look into the PostgreSQL Foreign key constraints using SQL statements. A foreign key is a column or a group of… Read More
In PostgreSQL, the ALTER TABLESPACE statement is used to rename, change the owner, or set parameters for a tablespace. Syntax: ALTER TABLESPACE tablespace_name action; To… Read More
In PostgreSQL a tablespace is used to map a logical name to a physical location on disk. In the simplest word, we can understand tablespace… Read More
PostgreSQL does not support the SHOW TABLES statement directly like MySQL does but provides users with an alternative. In this article, we will explore them… Read More
In PostgreSQL, there is no DESCRIBE statement as in MySQL. But users can query the information on columns of a table in a couple of… Read More
In PostgreSQL, the DROP TABLESPACE statement is used to remove a tablespace. Syntax: DROP TABLESPACE [IF EXISTS] tablespace_name; Let’s analyze the above syntax: First, specify… Read More
In PostgreSQL, the TRUNCATE TABLE statement is used to instantly delete all content from tables. Though we have a DELETE statement to delete all data… Read More