postgresql commands

Armandres answered on April 7, 2023 Popularity 10/10 Helpfulness 5/10

answer postgresql commands

postgresql commands

Comment

psql -U postgres -W # Enter Postgres console
\?	# View all posgres commands
\l # List all Databases
\dt # View all DB tables
\c DB_name # change Database nam
\d nombre_tabla # Describe table
\h # View all sql commands
\h nombre_de_la_funcion # Check how a sql command is executed
Ctrl + C # Cancel everything in console
SELECT version(); # View installed postgres version
\g # Execute last previous function again
\timing # Initialize time counter to show function execution time
Ctrl + L # Clean screen
\df # List all available functions of current DB 
\dv # List all views of actual DB
\du # List all users and roles of actual DB
\i filename # Execute sql commands from a file
\s filename # Save executed commands in a file
\q # Close console

Popularity 10/10 Helpfulness 5/10 Language sql

Source: Grepper

Tags: postgresql sql

Link to this answer
Share Copy Link

Contributed on Apr 07 2023

Armandres

0 Answers Avg Quality 2/10

postgresql commands

Contents

More Related Answers

postgresql commands

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.