INFORMATICS

The Best

Database SQL Prompt

Звезда не активнаЗвезда не активнаЗвезда не активнаЗвезда не активнаЗвезда не активна
 

Database SQL Prompt

Assume you have already launched your PostgreSQL client and you have landed at the following SQL prompt −

postgres=#

You can check the available database list using \l, i.e., backslash el command as follows −

postgres-# \l

OS Command Prompt

You can select your database from the command prompt itself at the time when you login to your database. Following is a simple example −

psql -h localhost -p 5432 -U postgress testdb

Search