How to find duplicate records in PostgreSQL?

I have a PostgreSQL database table called "user_links" which currently allows the following duplicate fields: year,...

psql: FATAL: role “postgres” does not exist?

I'm a postgres novice. I installed the postgres.app for mac. I was playing around with the psql commands and I acc...

psql: FATAL: role “postgres” does not exist?

I'm a postgres novice. I installed the postgres.app for mac. I was playing around with the psql commands and I acc...

How to create an SQL View with SQLAlchemy??

Is there a "Pythonic" way (I mean, no "pure SQL" query) to define an SQL view with SQLAlchemy? ...

PostgreSQL - query from bash script as database user 'postgres'?

I have a table in my PostgreSQL database which has 3 columns - c_uid, c_defaults and c_settings. c_uid simply stores...

Change security group on AWS RDS Database Instance?

I've created a Postgresql database instance via AWS RDS. I am now trying to connect to it from my django app, so I c...

psql: command not found Mac?

I installed PostgreSQL via the graphical install on http://www.postgresql.org/download/macosx/ I see it in my appli...

how to emulate “insert ignore” and “on duplicate key update” (sql merge) with postgresql??

Some SQL servers have a feature where INSERT is skipped if it would violate a primary/unique key constraint. For ins...

Postgres error on insert - ERROR: invalid byte sequence for encoding “UTF8”: 0x00?

I get the following error when inserting data from mysql into postgres. Do I have to manually remove all null chara...

org.postgresql.util.PSQLException: FATAL: no pg_hba.conf entry for host?

I am trying to connect to PostgreSQL database which is in remote location using Spring JDBC template. I am getting ...

Createuser: could not connect to database postgres: FATAL: role “tom” does not exist?

I'm trying to set up Postgres for the first time, and I need to create a user with permissions to read and create da...