Important PostgreSQL Commands

Introduction to PostgreSQL

[{"selector":"#anim-70a2c841-e6d1-4b54-99d6-67f6d3620875","keyframes":{"opacity":[0,1]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"both"}] [{"selector":"#anim-0659800e-6a63-45f0-992c-a58bd5fbccb8","keyframes":{"transform":["scale(0.3333333333333333)","scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}] [{"selector":"#anim-715b475d-f40f-4822-8134-3cd31c0e151d","keyframes":{"opacity":[0,1]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"both"}] [{"selector":"#anim-2f594211-143c-4cf1-bc9a-7a74dfec902d","keyframes":{"transform":["scale(0.3333333333333333)","scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}] [{"selector":"#anim-e047c62c-f158-4342-9ff7-ca4d071b504a [data-leaf-element=\"true\"]","keyframes":{"transform":["translate(0%, 0%) scale(1.5)","translate(0%, 0%) scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}] Learn More

PostgreSQL Commands List

[{"selector":"#anim-6ddbb770-f78d-42af-8510-9ea9d81fb96f","keyframes":{"opacity":[0,1]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"both"}] [{"selector":"#anim-97ed205c-9a15-4e0f-93f4-8f3e4ef31569","keyframes":{"transform":["scale(0.3333333333333333)","scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}] [{"selector":"#anim-b36ec45c-da0c-44fc-a00f-c20143bd9fca","keyframes":{"opacity":[0,1]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"both"}] [{"selector":"#anim-3fa4e2bd-1003-436a-9cab-9d85b8feaabb","keyframes":{"transform":["scale(0.3333333333333333)","scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}] [{"selector":"#anim-befd3228-05a2-4d66-b3f9-758a11d36a1a [data-leaf-element=\"true\"]","keyframes":{"transform":["translate(0%, 0%) scale(1.5)","translate(0%, 0%) scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}] [{"selector":"#anim-a6e32d3b-c750-4406-b271-4be6ac118beb","keyframes":{"opacity":[0,1]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"both"}] [{"selector":"#anim-7694dd9e-dcd6-4fd4-8f49-2e13fe77db03","keyframes":{"transform":["scale(0.3333333333333333)","scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}] Learn More

Switch the connection to a new database while logged in with an existing user. \c dbname username

[{"selector":"#anim-5fa6454f-9207-4af2-84b2-fb87698cbc9e","keyframes":{"opacity":[0,1]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"both"}] [{"selector":"#anim-edd3611d-4948-4210-88f9-b9f4956258e1","keyframes":{"transform":["scale(0.3333333333333333)","scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}] [{"selector":"#anim-dbabe1c6-17b1-495f-ac60-b79b16aef8b1 [data-leaf-element=\"true\"]","keyframes":{"transform":["translate(0%, 0%) scale(1.5)","translate(0%, 0%) scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}] [{"selector":"#anim-630802f3-1e0d-450c-b288-3d66c4332043","keyframes":{"opacity":[0,1]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"both"}] [{"selector":"#anim-2dfb8aef-c908-4776-8e32-8a540cc463ae","keyframes":{"transform":["scale(0.3333333333333333)","scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}] Learn More

Display a list all available databases in the current PostgreSQL database server. \l

[{"selector":"#anim-c05d883d-369a-4112-81f4-ea410d015aba","keyframes":{"opacity":[0,1]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"both"}] [{"selector":"#anim-a92518d5-09e5-4a51-9fe2-3592bd4ab8d2","keyframes":{"transform":["scale(0.3333333333333333)","scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}] [{"selector":"#anim-1a39956a-a437-43a4-a199-915dc2c253d4 [data-leaf-element=\"true\"]","keyframes":{"transform":["translate(0%, 0%) scale(1.5)","translate(0%, 0%) scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}] [{"selector":"#anim-309217e4-6700-4ccb-a38b-ae093009d40d","keyframes":{"opacity":[0,1]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"both"}] [{"selector":"#anim-5c037623-95a9-449c-9e01-9b184fd2b41e","keyframes":{"transform":["scale(0.3333333333333333)","scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}] Learn More

Display a list all available tables in the current database. \dt

[{"selector":"#anim-576214c0-3b55-487c-a942-b5a67d94527a [data-leaf-element=\"true\"]","keyframes":{"transform":["translate(25%, 0%) scale(1.5)","translate(0%, 0%) scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}] [{"selector":"#anim-13fdf52e-6c14-4b42-bc82-02d4ef239ede","keyframes":{"opacity":[0,1]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"both"}] [{"selector":"#anim-ceab1673-83c8-4276-b67b-30ea0a885c47","keyframes":{"transform":["scale(0.3333333333333333)","scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}] [{"selector":"#anim-dbdef74c-2976-4b87-a79a-9665225181bd","keyframes":{"opacity":[0,1]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"both"}] [{"selector":"#anim-125ec9e0-5f90-4408-bad0-070dd7a4dfa0","keyframes":{"transform":["scale(0.3333333333333333)","scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}] Learn More

Describe a table, such as a column, data type, column modifiers, and so on. \d table_name

[{"selector":"#anim-3c2fff42-00b9-4484-a87a-2f22ec0d33f1","keyframes":{"opacity":[0,1]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"both"}] [{"selector":"#anim-cf2c668d-b896-4d59-8e19-2c916c3901dc","keyframes":{"transform":["scale(0.3333333333333333)","scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}] [{"selector":"#anim-ff69f2b1-44f9-484e-9eb0-ed65f90aaa8a","keyframes":{"opacity":[0,1]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"both"}] [{"selector":"#anim-482eb4ad-b9f9-49b1-b230-e4ab8835386f","keyframes":{"transform":["scale(0.3333333333333333)","scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}] [{"selector":"#anim-ecb56278-3712-4bab-9f82-8ce04bf1074c [data-leaf-element=\"true\"]","keyframes":{"transform":["translate(0%, 0%) scale(1.5)","translate(0%, 0%) scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}] Learn More

Display a list all available schemas in the currently connected database. \dn

[{"selector":"#anim-001f0308-11a0-4c32-aaab-15ef5473f301","keyframes":{"opacity":[0,1]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"both"}] [{"selector":"#anim-e03395c0-c9c2-4526-aaaf-ce9a0cfe90e2","keyframes":{"transform":["scale(0.3333333333333333)","scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}] [{"selector":"#anim-9672a188-d045-476e-ae0b-d26f12a09df9 [data-leaf-element=\"true\"]","keyframes":{"transform":["translate(0%, 0%) scale(1.5)","translate(0%, 0%) scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}] [{"selector":"#anim-0e32fced-d44d-42b8-91f7-ea9a42755717","keyframes":{"opacity":[0,1]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"both"}] [{"selector":"#anim-ca5adc4a-0317-4047-9ff6-38bf4eb288ce","keyframes":{"transform":["scale(0.3333333333333333)","scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}] Learn More

Display a list of available functions in the current database. \df

[{"selector":"#anim-5e10d1c6-abd0-4744-b047-3bfda0014c2a","keyframes":{"opacity":[0,1]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"both"}] [{"selector":"#anim-2facb83d-f33d-44a4-ba64-a972cfd6ca79","keyframes":{"transform":["scale(0.3333333333333333)","scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}] [{"selector":"#anim-5de44d98-125e-4d13-81b3-857ebf17be9e [data-leaf-element=\"true\"]","keyframes":{"transform":["translate(0%, 0%) scale(1.5)","translate(0%, 0%) scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}] [{"selector":"#anim-4e7d7eed-f953-4a4c-a243-f9cd647f6cb8","keyframes":{"opacity":[0,1]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"both"}] [{"selector":"#anim-2e4314cb-9625-46a2-a9fe-6948523ea338","keyframes":{"transform":["scale(0.3333333333333333)","scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}] Learn More

For a Complete List of PostgreSQL Commands with examples.

[{"selector":"#anim-cf77124b-134e-440f-87af-7c397dcd7334","keyframes":{"opacity":[0,1]},"delay":0,"duration":1000,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-21292665-5b2e-49c5-8194-27e52491b3f2","keyframes":{"transform":["translate3d(0px, 161.14626%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":1000,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-477ee99f-e8ac-49c9-b4c3-b7a2a0338a30","keyframes":{"opacity":[0,1]},"delay":200,"duration":1000,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-a3e55bbb-8d9f-482b-bbf8-ae98ead8adec","keyframes":{"transform":["translate3d(0px, 293.70361%, 0)","translate3d(0px, 0px, 0)"]},"delay":200,"duration":1000,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] SWIPE UP

Important PostgreSQL Commands

Its all Here >>>

Introduction to PostgreSQL

PostgreSQL is an object-relational database system with a solid reputation for stability, robustness, and performance. It is used to store, manipulate and display data in an application.

PostgreSQL Commands List

Establishes a connection with the database under the control of the specified user. psql -d database -U user -W Here, -d = specifies database name and -U = specifies database user.

1. Connect to PostgreSQL Database

Switch the connection to a new database while logged in with an existing user. \c dbname username

2. Change the database connection to a new one

Display a list all available databases in the current PostgreSQL database server. \l

3. List available database

Display a list all available tables in the current database. \dt

4. List available table

Describe a table, such as a column, data type, column modifiers, and so on. \d table_name

5. Describe table

Display a list all available schemas in the currently connected database. \dn

6. List available schema

Display a list of available functions in the current database. \df

7. List available function

For a Complete List of PostgreSQL Commands with examples.

Click Here