postgresql Archives - IT Nursery

Programming, sql

IT Nursery

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 ...

June 4, 2022
0 Comments

postgresql, Programming

IT Nursery

Psql could not connect to server: No such file or directory, 5432 error?

I’m trying to run psql on my Vagrant machine, but I get this error: psql: could not connect to server: No such file ...

June 4, 2022
0 Comments

Programming, sql

IT Nursery

PostgreSQL: Which Datatype should be used for Currency?

Seems like Money type is discouraged as described here My application needs to store currency, which datatype shall I be using? Numeric, Money ...

June 4, 2022
0 Comments

postgresql, Programming

IT Nursery

How do I temporarily disable triggers in PostgreSQL?

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 ...

June 4, 2022
0 Comments

postgresql, Programming

IT Nursery

How to add column if not exists on PostgreSQL?

Question is simple. How to add column x to table y, but only when x column doesn’t exist ? I found only solution ...

June 3, 2022
0 Comments

postgresql, Programming

IT Nursery

PostgreSQL: role is not permitted to log in

I have trouble connecting to my own postgres db on a local server. I googled some similar problems and came up with this ...

June 3, 2022
0 Comments

postgresql, Programming

IT Nursery

Truncating all tables in a Postgres database

I regularly need to delete all the data from my PostgreSQL database before a rebuild. How would I do this directly in SQL? ...

June 3, 2022
0 Comments

Database, Programming

IT Nursery

Is it better to use multiple databases with one schema each, or one database with multiple schemas?

After this comment to one of my questions, I’m thinking if it is better using one database with X schemas or vice versa. ...

June 3, 2022
0 Comments

Programming, sql

IT Nursery

psql invalid command \N while restore sql

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 ...

June 3, 2022
0 Comments

Programming, sql

IT Nursery

How to concatenate columns in a Postgres SELECT?

I have two string columns a and b in a table foo. select a, b from foo returns values a and b. However, ...

June 3, 2022
0 Comments