How To Describe a Table in PostgreSQL
To describe tables in PostgreSQL, the “\dt”, “\dt+” or the “\d tab_name” meta-commands and “information_schema” are used.
How to Find String Length in PostgreSQL
In PostgreSQL, the length of the string can be found by using functions like LENGTH(), OCTET_LENGTH(), and BIT_LENGTH().
Understanding DATE Data Type in PostgreSQL
To create a DATE type column, specify the column’s name followed by the DATE keyword. By default, the DATE data type stores data in “YYYY-MM-DD” format.
ORDER BY Clause PostgreSQL- How to Sort Table’s Data
The ORDER BY clause sorts the data in a table. The sorting order can be specified as descending or ascending based on the user’s need.
WHERE Clause PostgreSQL – How to Filter Table’s Data
The WHERE clause is used with the SELECT statement to return the records that satisfy the condition given after the WHERE clause.
PostgreSQL UPDATE – How to Update Table Rows
To update the table values/data in PostgreSQL, the UPDATE command is used. This statement allows the user to update the previous data to new data values.
PostgreSQL SELECT – How to Select Table Records
In PostgreSQL, the SELECT statement is used with the FROM clause to get/fetch the required result from the specified table.
How to Rename the table in PostgreSQL
To rename a table in PostgreSQL, use the ALTER TABLE statement along with the RENAME TO clause. A table can be renamed manually using pgAdmin.
PostgreSQL INSERT – How to Insert New Rows into a Table
To insert values/rows into a Postgres table, use the INSERT INTO statement. The VALUE clause is used to specify the values that need to be inserted.
How to Add Primary Key Constraint to a Column in PostgreSQL
In Postgres, a Primary key can be added to a column during table creation. It can be added to an existing table using the ALTER TABLE ADD CONSTRAINT command.
PostgreSQL DELETE – How to Delete Table Rows
In PostgreSQL, the DELETE statement is used with the FROM clause to delete a single, multiple, or all rows of a specific table.
How to Change/Modify Column Type in PostgreSQL
To change or alter the data type of a specific table’s column, the ALTER TABLE command is used along with the ALTER COLUMN and TYPE clauses.
How to Rename the columns of a table in PostgreSQL
To rename the columns of the table in PostgreSQL, we can use the ALTER TABLE statement along with the RENAME COLUMN clause.
How to Create a Table in Postgres
To create a table in PostgreSQL, execute the CREATE TABLE statement either in pgAdmin or in psql. Postgres tables can also be created manually using pgAdmin.
How to Create a Database in Postgres
To create a database in PostgreSQL, execute the “CREATE DATABASE” command in the SQL Shell or pgAdmin. Users can also create databases manually using pgAdmin
How to Add Columns to a Table in PostgreSQL
In PostgreSQL, execute the ALTER TABLE statement along with the ADD COLUMN clause to add a new column to an already existing table.
How to Drop Columns From a Table in PostgreSQL
To drop/delete a column from a PostgreSQL table, we can use the ALTER TABLE statement and the DROP COLUMN clause together.
How to Drop a Table in Postgres
Execute the DROP TABLE command either in SQL Shell or in pgAdmin to drop a particular table in Postgres. A table can also be dropped manually using pgAdmin.
How to Drop a Database in PostgreSQL
To drop a database in PostgreSQL, the DROP DATABASE command can be executed either within the SQL Shell (psql) or pgAdmin.
How to Switch a Database in Postgres
To switch a database in Postgres, execute the “\c db_name” or “\connect db_name” command in psql. Or you can switch a database manually using pgAdmin.
