IT Nursery
This question already has answers here: How to concatenate strings of a string field in a PostgreSQL ‘group by’ query? (14 answers) Closed 9 years ago. I’m having a...
I’m trying to run psql on my Vagrant machine, but I get this error: psql: could not connect to server: No such file or directory Is the server running...
Seems like Money type is discouraged as described here My application needs to store currency, which datatype shall I be using? Numeric, Money or FLOAT? 6 Answers 6
I’m bulk loading data and can re-calculate all trigger modifications much more cheaply after the fact than on a row-by-row basis. How can I temporarily disable all triggers in...
Question is simple. How to add column x to table y, but only when x column doesn’t exist ? I found only solution here how to check if column...
I have trouble connecting to my own postgres db on a local server. I googled some similar problems and came up with this manual https://help.ubuntu.com/stable/serverguide/postgresql.html so: pg_hba.conf says: #...
I regularly need to delete all the data from my PostgreSQL database before a rebuild. How would I do this directly in SQL? At the moment I’ve managed to...
After this comment to one of my questions, I’m thinking if it is better using one database with X schemas or vice versa. I’m developing a web application where,...
I’m trying to restore my dump file, but it caused an error: psql:psit.sql:27485: invalid command \N Is there a solution? I searched, but I didn’t get a clear answer....
I have two string columns a and b in a table foo. select a, b from foo returns values a and b. However, concatenation of a and b does...