cederlof.net

postgresql

Nov 21, 2017
Share on:
 1#change to user postgres
 2sudo -i -u postgres
 3
 4#get into sql-mode
 5psql
 6
 7#create new role
 8createuser --interactive
 9
10#list dbs
11\l
12
13#select db
14\c database-name
15
16#list tables
17\dt
18
19#exit postgres
20\q

https://www.digitalocean.com/community/tutorials/how-to-install-and-use-postgresql-on-ubuntu-16-04

Recent Posts

  • Ubuntu Home Assistant Docker
  • Extract .pem and .key from .pfx certificate for Swish
  • Docker and ASP.NET MVC
  • Ubuntu files backups Onedrive
  • node-red
  • VIM Simple Vim VSCode VsVim
  • git cheat sheet
  • Kentor Authservices

Tags

TFS 4 XML 3 BUILD 2 CI 2 CODE-FIRST 2 ENTITY-FRAMEWORK 2 GIT 2 JAVASCRIPT 2 LINQ 2 SNIPPETS 2 SQL 2 SQL-SERVER 2 SUBLIME-TEXT 2 T-SQL 2
All Tags
ASP.NET1 BATCH1 BOXSTARTER1 BUILD2 C#1 CHEATSHEET1 CHOCOLATEY1 CI2 CODE-COVERAGE1 CODE-FIRST2 COLOR1 DEBUG1 DESIGN1 ENTITY-FRAMEWORK2 GIT2 GROOVY1 IIS1 INDEX1 JAVASCRIPT2 JQUERY1 LINKS1 LINQ2 LOG1 MMC1 MVC1 NHIBERNATE1 OBJECT1 OPENCOVER1 OSX1 PERFMON1 PERFORMANCE1 POWERSHELL1 REPORTGENERATOR1 SNIPPETS2 SOAPUI1 SQL2 SQL-SERVER2 SUBLIME-TEXT2 T-SQL2 TDD1 TEST-COVERAGE1 TFS4 TOOLS2 VIM1 VISUAL-STUDIO2 VISUAL-STUDIO-ONLINE1 WCF1 WEB-DEPLOY1 WEB-SERVICE1 WEB.CONFIG2 WINDOWS1 XML3
[A~Z][0~9]
cederlof.net

Copyright  CEDERLOF.NET. All Rights Reserved