Give your database a name, and click OK to finish. Once you’re connected, you can create a new table by clicking the database button, then the +. If you’re on a mac, make sure you’ve opened Postgres.app.

If you get an error like the one below, it’s because your server isn’t running.

Open up TablePlus and follow the instructions to create a new connection (right click + New > Connection).Īll of the defaults should be ok, although type in a password if you set one (on Windows it forces you to set one! Maybe you used your computer password?). Connecting TablePlus to your Postgres server You should be able to do all of your important with psql, but just in case you have weird issues - character encoding is a big one - you can use TablePlus (you downloaded this as prep already). That didn't work, but its behavior of adding it to the pane where the cursor was last works well.Using TablePlus to create and query Postgres databases Could this concept be expanded to include query results? My first instinct was also to try dragging and dropping one of the queries from my history into the desired pane. In addition to the query, it has the timestamp my terminal doesn't have that. The app has a nice query history sidebar. It would be nice to have a table view in one pane, and a query editor in the next. One limitation in the current implementation is it looks like table views need to take up the whole tab. Terminal has a lot of other disadvantages, but I've accumulated a lot of tricks to mitigate them.Ī nice implementation of tabs and panes could chip-away at that advantage, definitely, so this app is exciting. This is great for comparing results, printing out a few table schemas to help write a query, and acting as kind of a log of my thought process. The main reason I've been using the terminal instead of SequelPro is my terminal has the scrollback available from my previous queries. Today, I use mysql in the terminal most of the time. When you click on a row it also appears in a vertical orientation in the sidebar on the right, that's a nice touch. I love having multiple panes, multiple tabs, and good shortcuts.

Tableplus show stored procedure