{"id":75815,"date":"2020-09-08T10:45:13","date_gmt":"2020-09-08T10:45:13","guid":{"rendered":"https:\/\/www.whizlabs.com\/blog\/?p=75815"},"modified":"2020-09-11T11:31:24","modified_gmt":"2020-09-11T11:31:24","slug":"top-postgresql-commands","status":"publish","type":"post","link":"https:\/\/www.whizlabs.com\/blog\/top-postgresql-commands\/","title":{"rendered":"20 PostgreSQL Commands You Need to Learn"},"content":{"rendered":"

Aspiring to gain expertise in PostgreSQL and level up your database career? Here are the most common PostgreSQL commands for beginners to start with.<\/em><\/p>\n

The growth of the digital world has resulted in a promising rise in the need for open-source database management systems. PostgreSQL has been one of the trusted alternatives for the same for many years. However, the recent decade has witnessed a formidable rise in the popularity of PostgreSQL. It is presently a powerful choice for a significant role in various integrated data centers worldwide.<\/p>\n

PostgreSQL<\/a> is the go-to enterprise-level RDBMS with support for JSON and SQL alongside exceptionally high reliability. So, the demand for learning about PostgreSQL and PostgreSQL commands has increased considerably in recent times. PostgreSQL has been able to resolve the cost barriers for enterprises to access exclusive features available only in commercial databases like Oracle that are highly-priced.<\/p>\n

Check Now: Big Data Training Courses<\/a><\/p><\/blockquote>\n

Professionals working in the field of IT could use PostgreSQL expertise to pursue better career prospects in database-related roles. The following discussion provides you a detailed outline of some of the must-know PostgreSQL commands. Most important of all, you can reflect on the necessity of learning PostgreSQL. As a result, you can also understand the significance of learning commands for PostgreSQL before diving into a list of commands.<\/p>\n

Why Should You Learn PostgreSQL?<\/h2>\n

There is no doubt that relational databases have served as the backbone for applications for many years, irrespective of the arrival of many new technologies. PostgreSQL provides a free and open-source RDBMS that helps various multinational enterprises worldwide for helping developers in creating fault-tolerant environments while building apps.<\/p>\n

The features of PostgreSQL, such as compatibility, unparalleled performance, replication, SQL, compliance, security features, geo-tagging, and other notable features, have promoted its popularity and demand. So, if you are fluent enough to use the PostgreSQL commands effectively, then you can leverage all these features for improving your capabilities as database administrators.<\/p>\n

As a result, you can leverage the most from PostgreSQL while also improving your credibility in various database-related roles. PostgreSQL is also a prominent skill requirement in the field of data science, which is undoubtedly a treasure trove of career opportunities. Basically, everything related to data would be within your access with PostgreSQL expertise, and the best way to start would be to learn PostgreSQL commands. Here is an outline of the general commands in PostgreSQL. You must learn to develop your fluency in PostgreSQL.<\/p>\n

Top PostgreSQL Commands<\/h3>\n

The main tool for extracting the best potential of PostgreSQL is the command-line interface. If you know PostgreSQL commands well, then you can use PostgreSQL for achieving task objectives faster. In addition, fluency in commands also helps professionals in clearing up new opportunities for innovative use of PostgreSQL for different use cases.<\/p>\n

As a result, professionals can showcase better potential to make the best of practical applications of PostgreSQL. Here is an outline of the top common PostgreSQL commands that will help every beginner dive deeper into the world of PostgreSQL.<\/p>\n

1. Connecting to a Specific PostgreSQL Database<\/h4>\n

You can use the following command to connect with a specific database pertaining to a specific user. After you finish pressing \u2018Enter,\u2019 PostgreSQL would demand a password for the user.<\/p>\n

psql \u2013d database \u2013U user \u2013W<\/pre>\n
If you want to connect with a database \u2018students\u2019 related to the user \u2018academic,\u2019 then you can use the following command,<\/p>\n
C:\\Program Files\\PostgreSQL\\9.5\\bin>psql -d students -U academic -W<\/pre>\n
Password for user academic:<\/p>\n
students=#<\/em><\/pre>\n
2. Connecting with PostgreSQL Database on Another Database<\/h4>\n
On the other hand, if users want to connect with the database residing on another host, then they can use the \u2013h option. The example for such case would be as follows,<\/p>\n
psql \u2013h host \u2013d database \u2013U user \u2013W<\/pre>\n
3. Connecting to a Database in SSL Mode<\/h4>\n
Users can also implement SSL mode for the connection by specifying as mentioned in the following command,<\/p>\n
psql \u2013U user \u2013h host \u201cdbname=dbsslmode=require\u201d<\/pre>\n
4. Listing the Available Databases<\/h4>\n
Users can find this command as a general entry in almost any PSQL commands cheat sheet. You can use the following command for listing all the available databases in the existing PostgreSQL database server,<\/p>\n
\\l<\/pre>\n
5. Listing All the Available Tables<\/h4>\n
Users should also remember PostgreSQL commands with this functionality. The following command can help you list out all the tables in the existing database.<\/p>\n
\\dt<\/pre>\n
However, it is also important to remember that this command can display only the tables in the database connected currently.<\/p>\n
SQL is the base of all the database languages. Enroll in the SQL Basics Training Course<\/a> and start learning.<\/p><\/blockquote>\n
6. Switching Connection to a New Database<\/h4>\n
After connecting to a database, users could shift the connection to another database under a new user that the \u2018user\u2019 specifies. In addition, the previous connection is terminated, and the omission of the \u2018user\u2019 parameter implies that the existing \u2018user\u2019 is just implied. Here is the example of the command for switching a connection to a new database. The following command helps in connecting to the \u2018students\u2019 database under the \u2018academic\u2019 user,<\/p>\n
academic=# \\c students<\/pre>\n
You are now connected to database \u201cstudents\u201d as user \u201cacademic.\u201d<\/p>\n
students=#<\/pre>\n
7. Listing the Available Views in a PostgreSQL Database<\/h4>\n
The following PostgreSQL command can help you list all the available views in the existing database,<\/p>\n
\\dv<\/pre>\n
8. Listing the Available Schema<\/h4>\n
Users can find all the available schemas in the database they are presently connected to through the following command,<\/p>\n
\\dn<\/pre>\n
9. Describing a Table<\/h4>\n
Users should also know about the PostgreSQL commands for describing the specifications of a table. The following command can help in describing a table with the help of attributes such as column, modifiers of columns and type of table,<\/p>\n
\\d table_name<\/pre>\n
10. Listing Out the Available Functions<\/h4>\n
Functions are an important component in the operations of PostgreSQL. You can utilize the following command for finding out the list of available functions in a PostgreSQL database,<\/p>\n
\\df<\/pre>\n
11. Querying Data from a PostgreSQL Table<\/h4>\n
You can use PostgreSQL by querying or basically asking a question to the database. Users can use the following command for querying data from a table for the two specific columns c1 and c2,<\/p>\n
SELECT c1, c2 FROM t;<\/pre>\n
You can also use the following command for querying all the rows and columns from a specific table,<\/p>\n
SELECT * FROM t;<\/pre>\n
Users can also choose to implement certain conditions for querying data while filtering out certain rows with the following command,<\/p>\n
SELECT c1, c2 FROM t\r\n\r\nWHERE condition;<\/pre>\n
You should also know the following command for querying specific rows from a table along with the above-mentioned PostgreSQL commands,<\/p>\n
SELECT DISTINCT c1 FROM t\r\n\r\nWHERE condition;<\/pre>\n
12. Querying Data from Multiple Tables in PostgreSQL<\/h4>\n
Users should also learn the PostgreSQL commands that help in querying data from various tables. Here is an example of a command for querying data from two tables with an inner join,<\/p>\n
SELECT c1, c2\r\n\r\nFROM t1\r\n\r\nINNER JOIN t2 ON condition;\r\n\r\n<\/pre>\n
You can query data from two tables with left join by using the following command,<\/p>\n
SELECT c1, c2\r\n\r\nFROM t1\r\n\r\nLEFT JOIN t2 ON condition;<\/pre>\n
Users can also make the most of the following command for querying data from two tables with right join,<\/p>\n
SELECT c1, c2\r\n\r\nFROM t1\r\n\r\nRIGHT JOIN t2 ON condition;<\/pre>\n
You can also perform a total outer join of two tables for querying data from them with the help of the following command,<\/p>\n
SELECT c1, c2\r\n\r\nFROM t1\r\n\r\nFULL OUTER JOIN t2 ON condition;<\/pre>\n
13. Index Management<\/h4>\n
The PostgreSQL commands for managing indexes are one of the most advanced topics in ensuring the database management expertise with PostgreSQL. Here is an example command for creating an index of a table\u2018t\u2019 on c1 and c2,<\/p>\n
CREATE INDEX idx_name\r\n\r\nON t(c1,c2);<\/pre>\n
The following command can help users in creating a specific index of the table \u2018t\u2019 on c3 and c4,<\/p>\n
CREATE UNIQUE INDEX idx_name\r\n\r\nON t(c3,c4);<\/pre>\n
You can also use the following command for deleting an index,<\/p>\n
DROP INDEX idx_name;<\/pre>\n
14. Creation of Table in PostgreSQL<\/h4>\n
Tables are undoubtedly a significant aspect of PostgreSQL utilization. So, it is important to know about the commands for creating a table. Here is the example for PostgreSQL commands for creating a new table that has three distinct columns,<\/p>\n
CREATE TABLE t (\r\n\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 id SERIAL PRIMARY KEY,\r\n\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 subject VARCHAR NOT NULL,\r\n\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 grade NUMERIC (10,2) DEFAULT 0\r\n\r\n);<\/pre>\n
15. Management of Tables in PostgreSQL<\/h4>\n
Professionals with expertise over a wide range of PostgreSQL commands for managing tables can achieve better control over the language. You can use the following example commands for various operations on tables.<\/p>\n
Here is an example code for deleting a table from a concerned database<\/p>\n
DROP TABLE t CASCADE;<\/pre>\n
You can delete a column \u2018c\u2019 from a table with the following command,<\/p>\n
ALTER TABLE t DROP COLUMN c;<\/pre>\n
Users can add a new column to a specific table by leveraging the following command,<\/p>\n
ALTER TABLE t ADD column;<\/pre>\n
You also have the option for adding or removing constraints on a table by using the following commands respectively,<\/p>\n
ALTER TABLE t ADD constraint;\r\n\r\nALTER TABLE t DROP constraint;<\/pre>\n
If you want to remove all data in a specific table, then you can use the following command,<\/p>\n
TRUNCATE TABLE t CASCADE;<\/pre>\n
Users can also rename tables or columns by using the following commands respectively,<\/p>\n
ALTER TABLE t1 RENAME TO t2;\r\n\r\nALTER TABLE t1 RENAME c1 to c2;<\/pre>\n
16. Commands for Management of Views in PostgreSQL<\/h3>\n
PostgreSQL users should be acquainted with the significance of views in the management of relational databases. Here are the must-know PostgreSQL commands for management of views for faster and efficient use of database management systems.<\/p>\n
The following command example can help you develop a new view that includes c1 and c2,<\/p>\n
CREATE VIEW v(c1,c2)\r\n\r\nAS\r\n\r\nSELECT c1, c2\r\n\r\nFROM t;<\/pre>\n
Users can also prefer to associate a check option while creating a new view. The following command example can help you achieve the same,<\/p>\n
CREATE VIEW v(c1,c2)\r\n\r\nAS\r\n\r\nSELECT c1, c2\r\n\r\nFROM t;\r\n\r\nWITH [CASCADED | LOCAL] CHECK OPTION;<\/pre>\n
You could also create a temporary view with the help of the following command,<\/p>\n
CREATE TEMPORARY VIEW v\r\n\r\nAS\r\n\r\nSELECT c1, c2\r\n\r\nFROM t;<\/pre>\n
In addition, users could also develop a recursive view in PostgreSQL with the following command,<\/p>\n
CREATE RECURSIVE VIEW v\r\n\r\nAS\r\n\r\nselect-statement \u2013 anchor part\r\n\r\nUNION [ALL]\r\n\r\nselect-statement; -- recursive part<\/pre>\n
The final mention among PostgreSQL commands for managing views is the command for deleting a view. The example command for deleting a view is as follows,<\/p>\n
DROP VIEW view_name<\/pre>\n
17. User-related PostgreSQL Commands<\/h4>\n
The PostgreSQL commands related to users are essential for maintaining efficient and faster processing. The commands help in strengthening the control over user administration for database management professionals. Here is a command for listing the users in the current database,<\/p>\n
\\du<\/pre>\n
The following command example would list out a username if it is present,<\/p>\n
\\du_username_<\/pre>\n
\u00a0You can also create a role having an already existing username by using the following command,<\/p>\n
create role _test1_<\/pre>\n
You can also add username and password while creating a role with the help of the following command,<\/p>\n
create role _test2_ noinherit login password _password_;<\/pre>\n
It is also possible to switch roles with the help of the following command,<\/p>\n
Grant _test2_ to _test1_;<\/pre>\n
You could also change the role for a current session to _test_ with the following command,<\/p>\n
set role _test_<\/pre>\n
One of the most important PostgreSQL commands for user management is the following mention for listing out the entire user mapping on the server,<\/p>\n
\\deu+<\/pre>\n
18. Utilizing SQL Constraints<\/h4>\n
Professionals aspiring for expertise in PostgreSQL must also have comprehensive fluency in using SQL constraints to their advantage. Here are some of the notable PostgreSQL commands that can help you make the most of SQL constraints in various use cases.<\/p>\n
You can establish c1 and c2 as the primary key for a table by using the following command,<\/p>\n
CREATE TABLE t(\r\n\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 c1 INT, c2 INT, c3 VARCHAR,\r\n\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 PRIMARY KEY (c1,c2)\r\n\r\n);<\/pre>\n
Users can also opt for setting a specific column \u2018c2\u2019 in the form of a foreign key by using the following command,<\/p>\n
CREATE TABLE t1(\r\n\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 c1 SERIAL PRIMARY KEY,\r\n\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 c2 INT,\r\n\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 FOREIGN KEY (c2) REFERENCES t2(c2)\r\n\r\n);<\/pre>\n
You can also use the following command for establishing uniqueness in the values of c1 and c2,<\/p>\n
CREATE TABLE t9\r\n\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 c1 INT, c1 INT,\r\n\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 UNIQUE (c2,c3)\r\n\r\n);<\/pre>\n
The following PostgreSQL command can help in establishing the values in a column \u2018c2\u2019 as non-NULL,<\/p>\n
CREATE TABLE t(\r\n\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 c1 SERIAL PRIMARY KEY,\r\n\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 c2 VARCHAR NOT NUL\r\n\r\n);<\/pre>\n
Users could also improve the control of the constraints in PostgreSQL databases by ensuring that c1 is greater than 0, and the values in c1 are greater than or equal to that in c2. Here is the example code for achieving the same,<\/p>\n
CREATE TABLE t(\r\n\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 c1 INT, c2 INT,\r\n\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 CHECK (c1> 0 AND c1 >= c2)\r\n\r\n);<\/pre>\n
19. Setting Operations for SQL Databases<\/h4>\n
PostgreSQL commands for SQL databases would also help professionals develop their fluency in leveraging for PostgreSQL to address various use cases productively.<\/p>\n
The following example would help you in combining the result set from two or multiple queries by using the UNION operator,<\/p>\n
SELECT * FROM table1\r\n\r\nUNION\r\n\r\nSELECT * FROM table2;<\/pre>\n
Users can also find an intersection of the result sets of two queries by the following command,<\/p>\n
SELECT * FROM table1\r\n\r\nINTERSECT\r\n\r\nSELECT * FROM table2;<\/pre>\n
Another notable use of PostgreSQL commands could also help in excluding a result set from the queries with the help of EXCEPT operator. The following example command can show how,<\/p>\n
SELECT * FROM table1\r\n\r\nEXCEPT\r\n\r\nSELECT * FROM table2;\r\n\r\n20. Data Modifications<\/pre>\n
If you want to work with PostgreSQL, then you have to deal with data. So, the PostgreSQL commands for data modifications are very crucial for all PostgreSQL professionals and learners. Here are some of the commands for data modification that you would find in a PSQL commands cheat sheet.<\/p>\n
The example command for inserting a new row into a specific table is as follows,<\/p>\n
INSERT INTO table(column1, column2,\u2026)\r\n\r\nVALUES (values_1, value_2,\u2026);<\/pre>\n
Users can find the following command useful for updating the data for all rows,<\/p>\n
UPDATE table_name\r\n\r\nSET column_1 = value_1,\r\n\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u2026;<\/pre>\n
The following command example can showcase the use of PostgreSQL commands for inserting multiple rows in a specific table.<\/p>\n
INSERT INTO table_name(column1, column2,\u2026)\r\n\r\nVALUES (value_1, value_2, \u2026),\r\n\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 (value_1, value_2, \u2026),\r\n\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 (value_1, value_2, \u2026)\u2026<\/pre>\n
The following command is also important as it can help you delete all the rows of a specific table,<\/p>\n
DELETE FROM table_name;<\/pre>\n
Users could also find the following helpful PostgreSQL command for updating data according to the requirements of a specific set of rows according to conditions specified with a \u2018WHERE\u2019 clause.<\/p>\n
UPDATE table\r\n\r\nSET column_1 = value_1,\r\n\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u2026\r\n\r\nWHERE condition;<\/pre>\n
Users can also find PostgreSQL commands for deleting specific rows according to specific conditions as the following example,<\/p>\n
DELETE FROM table_name\r\n\r\nWHERE condition;<\/pre>\n
Preparing for a Big Data Interview? Go through these frequently-asked Big Data Interview Questions<\/a> and get ready to ace the interview.<\/p><\/blockquote>\n
Conclusion<\/h3>\n
On a final note, it is clearly evident that PostgreSQL provides efficient functionalities with very simple coding requirements. The easy-to-remember PostgreSQL commands, along with the regular hands-on practice, could provide the much-needed confidence for beginners. In addition, the cheat sheet of commands for PostgreSQL can also be a great asset for database administrators and developers.<\/p>\n
Therefore, knowledge of commands for using PostgreSQL can give substantial advantages to the preparation of candidates for different job interviews. Expertise in commands of PostgreSQL also strengthens the hands-on experience of aspiring database professionals. With the demand for PostgreSQL sustaining the arrival of new database management technologies, candidates should start mastering more commands right now!<\/p>\n
If you’re preparing to enhance your Big Data skills<\/p>\n","protected":false},"excerpt":{"rendered":"
Aspiring to gain expertise in PostgreSQL and level up your database career? Here are the most common PostgreSQL commands for beginners to start with. The growth of the digital world has resulted in a promising rise in the need for open-source database management systems. PostgreSQL has been one of the trusted alternatives for the same for many years. However, the recent decade has witnessed a formidable rise in the popularity of PostgreSQL. It is presently a powerful choice for a significant role in various integrated data centers worldwide. PostgreSQL is the go-to enterprise-level RDBMS with support for JSON and SQL […]<\/p>\n","protected":false},"author":220,"featured_media":76052,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_uag_custom_page_level_css":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[6],"tags":[3707,3708,3706],"class_list":["post-75815","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-big-data","tag-learn-postgresql-commands","tag-must-know-postgresql-commands","tag-psql-commands-cheat-sheet"],"uagb_featured_image_src":{"full":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2020\/08\/postgresql-commands-you-need-to-learn.jpg",600,315,false],"thumbnail":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2020\/08\/postgresql-commands-you-need-to-learn-150x150.jpg",150,150,true],"medium":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2020\/08\/postgresql-commands-you-need-to-learn-300x158.jpg",300,158,true],"medium_large":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2020\/08\/postgresql-commands-you-need-to-learn.jpg",600,315,false],"large":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2020\/08\/postgresql-commands-you-need-to-learn.jpg",600,315,false],"1536x1536":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2020\/08\/postgresql-commands-you-need-to-learn.jpg",600,315,false],"2048x2048":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2020\/08\/postgresql-commands-you-need-to-learn.jpg",600,315,false],"profile_24":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2020\/08\/postgresql-commands-you-need-to-learn.jpg",24,13,false],"profile_48":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2020\/08\/postgresql-commands-you-need-to-learn.jpg",48,25,false],"profile_96":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2020\/08\/postgresql-commands-you-need-to-learn.jpg",96,50,false],"profile_150":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2020\/08\/postgresql-commands-you-need-to-learn.jpg",150,79,false],"profile_300":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2020\/08\/postgresql-commands-you-need-to-learn.jpg",300,158,false],"tptn_thumbnail":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2020\/08\/postgresql-commands-you-need-to-learn-250x250.jpg",250,250,true],"web-stories-poster-portrait":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2020\/08\/postgresql-commands-you-need-to-learn.jpg",600,315,false],"web-stories-publisher-logo":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2020\/08\/postgresql-commands-you-need-to-learn.jpg",96,50,false],"web-stories-thumbnail":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2020\/08\/postgresql-commands-you-need-to-learn.jpg",150,79,false]},"uagb_author_info":{"display_name":"Aditi Malhotra","author_link":"https:\/\/www.whizlabs.com\/blog\/author\/aditi\/"},"uagb_comment_info":1,"uagb_excerpt":"Aspiring to gain expertise in PostgreSQL and level up your database career? Here are the most common PostgreSQL commands for beginners to start with. The growth of the digital world has resulted in a promising rise in the need for open-source database management systems. PostgreSQL has been one of the trusted alternatives for the same…","_links":{"self":[{"href":"https:\/\/www.whizlabs.com\/blog\/wp-json\/wp\/v2\/posts\/75815","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.whizlabs.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.whizlabs.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.whizlabs.com\/blog\/wp-json\/wp\/v2\/users\/220"}],"replies":[{"embeddable":true,"href":"https:\/\/www.whizlabs.com\/blog\/wp-json\/wp\/v2\/comments?post=75815"}],"version-history":[{"count":4,"href":"https:\/\/www.whizlabs.com\/blog\/wp-json\/wp\/v2\/posts\/75815\/revisions"}],"predecessor-version":[{"id":76054,"href":"https:\/\/www.whizlabs.com\/blog\/wp-json\/wp\/v2\/posts\/75815\/revisions\/76054"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.whizlabs.com\/blog\/wp-json\/wp\/v2\/media\/76052"}],"wp:attachment":[{"href":"https:\/\/www.whizlabs.com\/blog\/wp-json\/wp\/v2\/media?parent=75815"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.whizlabs.com\/blog\/wp-json\/wp\/v2\/categories?post=75815"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.whizlabs.com\/blog\/wp-json\/wp\/v2\/tags?post=75815"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}