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 table like this Movie Actor A 1 A 2 A 3 B 4 I want to get the name of a movie and all actors in … 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 or directory Is the server running locally and accepting connections on Unix domain socket “/var/run/postgresql/.s.PGSQL.5432”? Note: Vagrant 1.9.2 Box: ubuntu/trusty64, https://atlas.hashicorp.com/ubuntu/boxes/trusty64 EDIT Commands I’ve used in order to install and run postgres: … 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 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 PostgreSQL? 7 Answers 7
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 exists. SELECT column_name FROM information_schema.columns WHERE table_name=”x” and column_name=”y”; 11 Answers 11
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: # TYPE DATABASE USER ADDRESS METHOD # “local” is for Unix domain socket connections only local all all trust # IPv4 local connections: host all all 127.0.0.1/32 … 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? At the moment I’ve managed to come up with a SQL statement that returns all the commands I need to execute: SELECT ‘TRUNCATE TABLE ‘ || tablename || ‘;’ FROM pg_tables WHERE … 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. I’m developing a web application where, when people register, I create (actually) a database (no, it’s not a social network: everyone must have access to his own data and never see the … 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 I didn’t get a clear answer. 16 Answers 16
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 not work. I tried : select a || b from foo and select a||’, ‘||b from foo Update from comments: both columns are type character(2). 8 … Read more
