Przełącznik języka
Tools
Mining
Security
CMS
Hardware
Backup
Windows Server
Databases
Emulators
Powershell
Storage Array
Active Directory
SEO
MSSQL
Antivirus program
Linux
Licznik
Visitor Info
- IP: 18.219.231.197
- Browser: Unknown
- Browser Version:
- Operating System: Unknown
Who Is Online
3
Online
Viernes, 22 Noviembre 2024 17:06
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