postgresql Archives - Page 12 of 21

In MS SQL-Server, I can do: SELECT ISNULL(Field,'Empty') from Table But in PostgreSQL I get a syntax error. How do I emulate the ...

I’m looking to update multiple rows in PostgreSQL in one statement. Is there a way to do something like the following? UPDATE table ...

Upon restarting my Mac I got the dreaded Postgres error: psql: could not connect to server: No such file or directory Is the ...

I’m adding a new, “NOT NULL” column to my Postgresql database using the following query (sanitized for the Internet): ALTER TABLE mytable ADD ...

I have been trying to set up a container for a development postgres instance by creating a custom user & database. I am ...

I’m trying to install PostgreSQL’s pg gem for Ruby. I issued the following command: gem install pg I installed Ruby 1.9.2 using RVM. ...

I have a table with this layout: CREATE TABLE Favorites ( FavoriteId uuid NOT NULL PRIMARY KEY, UserId uuid NOT NULL, RecipeId uuid ...

I’m doing a web app, and I need to make a branch for some major changes, the thing is, these changes require changes ...

I have a table column that uses an enum type. I wish to update that enum type to have an additional possible value. ...