/Test-API-Csharp

Primary LanguageC#MIT LicenseMIT

Test-API-Csharp

Install PostgreSQL

  • sudo apt update
  • sudo apt install postgresql postgresql-contrib
  • sudo service postgresql start [stop, status, reload, restart]

Version Postgresql

sudo -u postgres psql -c "SELECT version();"

Start Postgres Shell

  • sudo -u postgres psql
  • pass= root

Set Password

  • ALTER USER postgres WITH PASSWORD 'root';

Basic Postgres Commands

  • \q: Quit
  • \c database: Connect to a database
  • \d table: Show table definition including triggers
  • \dt .: List tables from all schemas (if . is omitted will only show SEARCH_PATH ones)
  • \l: List databases
  • \dn: List schemas
  • \df: List functions
  • \dv: List views
  • \timing: Show query timing stats

Built with

this project was built in: .NET, PostgreSQL

Contact with mehandshake

Github logo email logo Linkedin Logo Twitter Logo

License

Test-API-Csharp is open source and therefore free to download and use without permission.