0

if I want to connect to POSTGRESQL db with a Linux user that I've created, let's say "Joe", should I locate pgadmin folder within python environment under Joe's folder?

karel
  • 110,292
  • 102
  • 269
  • 299
glc78
  • 481
  • 2
  • 6
  • 13
  • How and where was the db created? – 4mAstro Aug 09 '17 at 04:20
  • @4mAstro With psql command `creatdb joe`, logged with user "joe" as this guide suggests: [guide](https://www.digitalocean.com/community/tutorials/how-to-install-and-use-postgresql-on-ubuntu-16-04) – glc78 Aug 09 '17 at 09:33

1 Answers1

0

Login using:

$ psql -U joe

List databases using:

joe=>\l

Connect to desired database using:

joe=>\c <database_name>
4mAstro
  • 66
  • 7
  • Sorry but I don't understand what is this for. During the installation of Pgadmin a folder named 'pagdmin' has been created under `/home/myname/`, and inside there is the python environment. If I create another user, joe, so that I have '/home/joe/` can he access to Pgadmin service regularly or does he need his private copy of Pgadmin folder and python environment? Maybe my question is stupid, but I'm new in Linux/Ubuntu. – glc78 Aug 12 '17 at 11:45
  • This is how you connect to the database in the terminal. Pgadmin is different but I dont remember off the top of my head. – 4mAstro Aug 12 '17 at 17:25