What is PostgreSQL equivalent tool for SQL*PLUS command-line tool of an oracle database?
meda Changed status to publish 07/03/2022
PSQL is a PostgreSQL command-line scripting tool that enables us to connect to PostgreSQL database.
Example:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 | Server [localhost]:Database [postgres]:Port [5432]:Username [postgres]:Password for user postgres:psql (13.5)WARNING: Console code page (437) differs from Windows code page (1252) 8-bit characters might not work correctly. See psql reference page "Notes for Windows users" for details.Type "help" for help. postgres=# select version(); version------------------------------------------------------------ PostgreSQL 13.5, compiled by Visual C++ build 1914, 64-bit(1 row) postgres=# |
Ezana Answered question 27/02/2022