PostgreSQL - do I need command line tools?

David Blomstrom

I decided to try PostgreSQL. It does look interesting, but it's not very user friendly.

I got great help from the PostgreSQL email list, but they insist that the tool to use is a command line editor (PSQL). Unfortunately, it was a total disaster. When I turn it on, it opens at least two instances, which quickly grow to twelve. It also seems to have somehow hijacked the Apple Terminal on the Mac. I can type the same command in two different junction boxes and get two different results. I don't know what happened.

Anyway, to get to the point, PostgreSQL is clearly giving me a headache. There is a local PostgreSQL user group that meets once a month and in the evenings when I'm at work. However, I would like to try to make some notes at the beginning of the next meeting and leave them a note. I'd like to hire someone to help me install PostgreSQL on my laptop and online, troubleshoot any issues, and show me how to create databases and tables.

In fact, I have created a database and tables which I can access using pgAdmin III. But I can't see them in shell/terminal. So here's my question: If I can hire someone to get PostgreSQL up and running, can I use pgAdmin III or other tools to use it, or do I have to link to the shell (PSGL)?

If the housing/terminals are essential, then I guess I'll drop it. It looks like a great program, but I don't have time to jump through all the trouble right now.

Craig Ringer

You don't need psqlto use PostgreSQL. Many experienced users love it, but you can only use PgAdmin and everything is fine. This is what many users do.

PostgreSQL works great on Mac OS X. Many core developers use and develop on Mac OS X. Like many MySQL users use phpmyadmin etc, never use mysqlcommand line tools.

There were some packaging issues on OS X related to Apple's bundling of PostgreSQL, but these have been resolved in the latest version of OS X.

There are also some challenges with using different PostgreSQL packages (EnterpriseDB, Macports, Homebrew, etc.) on OS X. Each package is good on its own. A similar problem exists on Linux, where OS packages, PGDG packages, and EDB's packages can step on each other's toes.

By the way, it's interesting to describe the PostgreSQL community as a "Microsoft/Linux fan club". Most of the core developers and users on the mailing list tolerate Windows at best.

It's hard to tell what problem you are having based on the description given. Maybe you have multiple different PostgreSQL packages installed, so you have multiple server instances and you're getting them confused? Again, I can't figure out what's going on with the terminal link in the psqldock . If you want to use it, I'd ignore it and use it psqlfrom the usual Apple . Otherwise, just use PgAdmin.Terminal.apppsql

One area where you're going to have trouble is, since most experienced users are on psql, if you're asking a specific question about PgAdmin or other tools, not PostgreSQL itself, people will shrug and say "dunno, but you Doing this "in psql". I haven't used PgAdmin for my own stuff in years, and if I want to figure out how to do something, I can look around in the manual so I can explain it to others. Also, there's something I've gotten from Something like Navicat that hasn't been used. The people who use these tools are usually not the people who spend their time helping other people , so you get help from experienced and enthusiastic users who are also most likely to use expert-oriented tool man.

Related link : http://phili.pe/posts/postgresql-on-the-command-line/

Related

PostgreSQL - do I need command line tools?

David Blomstrom I decided to try PostgreSQL. It does look interesting, but it's not very user friendly. I got great help from the PostgreSQL email list, but they insist that the tool to use is a command line editor (PSQL). Unfortunately, it was a total disaste

What do I need to reference in the sed command line?

p There are many questions on this site about how to escape various elements of sed, but I'm looking for a more general answer. I know I might want to escape some characters to avoid shell expansion: Bash : Single quotes [strings] ('') are used to preserve the

How do I use mwdumper in Postgresql command line

Gabi I am using mwdumper and MySql to import a MediaWiki database. Now I need to do the same thing, but with Postgresql. Basically, I got the archive at this link: http://dumps.wikimedia.org/enwiki/20140903/ I use the mwdumper program to get the information an

How do I use mwdumper in Postgresql command line

Gabi I am importing a MediaWiki database using mwdumper with MySql. Now, I need to do the same thing, but with Postgresql. Basically, I got the archive at this link: http://dumps.wikimedia.org/enwiki/20140903/ I use the mwdumper program to get the information

How do I use mwdumper in Postgresql command line

Gabi I am importing a MediaWiki database using mwdumper with MySql. Now, I need to do the same thing, but with Postgresql. Basically, I got the archive at this link: http://dumps.wikimedia.org/enwiki/20140903/ I use the mwdumper program to get the information

How do command line tools communicate with browsers?

Junke | This is a command line tool force-cli When used force login, it will open a browser and ask for Oauth login. After authorization, the browser will close and return to the command line tool. I am new to command line tools (Terminal.app or cmd.exe) My qu

Cypress command line tools do not respect arguments

Janak Ramakrishnan I didn't use npm, so I downloaded Cypress directly. I can open Cypress binaries directly from the command line, but I can't get it to run tests from the command line. Running Cypress runjust opens the UI. Cypress run --project /path/to/my/pr

Cypress command line tools do not respect arguments

Janak Ramakrishnan I didn't use npm, so I downloaded Cypress directly. I can open Cypress binaries directly from the command line, but I can't get it to run tests from the command line. Running Cypress runjust opens the UI. Cypress run --project /path/to/my/pr

Cypress command line tools do not respect arguments

Janak Ramakrishnan I didn't use npm, so I downloaded Cypress directly. I can open Cypress binaries directly from the command line, but I can't get it to run tests from the command line. Running Cypress runjust opens the UI. Cypress run --project /path/to/my/pr

I need command line for Linux and MacOS

Encoding with Adin So I know the command line Windows needs: cd src java -cp . mazesolver.SolverCode Now I need the content of these lines: Mac OS and Linux Lori It's the same thing. Be careful not to use functions that are only available for the specified op