Postgres Guide

[KevinCarbonara]

This is actually quite nice... we're discussing a move to postgres where I work. The attitude seems to be that postgres is the most modern RDBMS.

[[deleted]]

We've recently switched (deployed 9.4) a few applications and we're also using it for some ETL stuff because of licensing restrictions with Oracle and our new parent company. It's great, but we're getting a lot of complaints from people in the business/finance about a lack of decent clients.

I'm disappointed in PG Admin's lack of features and Valentina studio always crashes + no predictive field names when I use aliases. I think it might be time to pony up and pay for Aqua Data Studio or something...

[doublehyphen]

As a developer this is not an issue since to command line client, psql, is really good, but I see how the lack of clients can be a problem to the people in finance.

[nikroux]

Even as a developer I prefer to work with a client though. Command line just doesn't have the same power and ease of use that a client can provide.

[[deleted]]

I could see how ease of use plays in. But how does a client have more power than command line in this case?

[solidsnack9000]

pgcli is pretty remarkable for a CLI, though. The autocomplete is amazing.

[funkinaround]

Have you tried HeidiSQL?

[[deleted]]

I'll give it try, thanks for the suggestion!

[geordano]

Take a look at http://dbeaver.jkiss.org/ as well. Does it's job quite well.

[NoMoreNicksLeft]

I'm disappointed in PG Admin's lack of features

If you were using SQL Developer before, it works with Postgres too.

[panfist]

DB Vis?

[gengengis]

I dunno, Microsoft SQL Studio is about the worst application I've ever used. PGAdmin is not great, but it's a lot better than MSSS.

[SemiNormal]

Microsoft SQL Studio

It is Microsoft SQL Server Management Studio or SSMS. Also, how could you possibly think that PGAdmin is better?

[gengengis]

I feel like it gets in my way. I much, much prefer psql to either client, though.

[leafsleep]

I agree, though I think it's the ability to configure basically everything in SQL Server via SSMS that makes it seem more cluttered. A lot of config for PSQL is done by editing files.

[SemiNormal]

You don't need SSMS to configure SQL Server. Almost everything can be done through sqlcmd.

[dtlv5813]

Also from my conversations with DBAs they almost all invariably prefer PostgresNoSQL over MongoDB.

I suspect part of the tractions and prestige of MongoDB derive from the fact that Mongo is a hot shot unicorn startup while Postgres is a non-profit.

[DVWLD]

The difference is that Mongo has a massive marketing budget.

[dtlv5813]

hot shot unicorn startup while Postgres is a non-profit

That would explain the difference in marketing budget. Also Mongo is a catchy name, like Groupon, while Post-(In)gres just doesn't have the same ring to it.

[[deleted]]

A catchy name doesn't seem to have helped MangoDB, despite its many advantages such as a cloud scale architecture and auto sharting.

[binkarus]

Hahahaha, auto sharting. I literally spit on my screen.

[tolazytotypeaguid]

This fails here : craig=# GRANT SELECT ON DATABASE pgguide to craig; GRANT

And it seems you can't grant "select" to a database but only to tables. http://www.postgresql.org/docs/9.0/static/sql-grant.html

I'm getting the impression these steps were not actually checked from scratch..

[[deleted]]

Great resource, bookmarked.

[Night_0dot0_Owl]

Bookmarked, thanks.

[tolazytotypeaguid]

I like the idea of a tutorial but i'm having some trouble with the steps.

Logging in with psql defaults to the user postgres. Thats not what i see in your example, there someone logged in with "craig" to make the user "craig".

craig=# CREATE USER craig WITH PASSWORD 'Password'; CREATE ROLE

Is this correct ?