Concatenate multiple result rows of one column into one, group by another column [duplicate]
This question already has answers here: How to concatenate strings of a string field in a PostgreSQL ‘group by’ query? (14 answers) Closed … Read more
This question already has answers here: How to concatenate strings of a string field in a PostgreSQL ‘group by’ query? (14 answers) Closed … Read more
I’m trying to run psql on my Vagrant machine, but I get this error: psql: could not connect to server: No such file … Read more
Seems like Money type is discouraged as described here My application needs to store currency, which datatype shall I be using? Numeric, Money … Read more
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 … Read more
Question is simple. How to add column x to table y, but only when x column doesn’t exist ? I found only solution … Read more
I have trouble connecting to my own postgres db on a local server. I googled some similar problems and came up with this … Read more
I regularly need to delete all the data from my PostgreSQL database before a rebuild. How would I do this directly in SQL? … Read more
After this comment to one of my questions, I’m thinking if it is better using one database with X schemas or vice versa. … Read more
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 … Read more
I have two string columns a and b in a table foo. select a, b from foo returns values a and b. However, … Read more