python (65.1k questions)

javascript (44.2k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (12.9k questions)

Questions - psql

Meaning of the character @ in psql

I found the next psql command: CREATE TABLE @cdmDatabaseSchema.PERSON ( person_id integer NOT NULL, gender_concept_id integer NOT NULL, year_of_birth integer NOT NU...
test-img

Jose Cabrera Zuniga

postgresql

psql

Votes: 0

Answers: 0

Postgresql: Able to authenticate using psql but unable to backup with pg_dump

I have trouble backing up a PostgreSQL database. When I run the following command: psql -d cdb -U "$(whoami)" The result: cdb=# \c You are now connected to database "cdb" as user ...
test-img

Christian Hick

postgresql

psql

pg-dump

Votes: 0

Answers: 1

Latest Answer

With psql, you are using a local connection via domain sockets, since you didn't specify -h localhost, so the first or second pg_hba.conf line applies, and you can connect without a password. With pg_...
test-img

Laurenz Albe

Pivot and aggregate 1..n duplicate records Postgres psql

I have a table tbl_action like this: game_id action action_datetime 1 start 2022-04-05T10:30+00 1 attack 2022-04-05T10:45+00 1 defend 2022-04-05T11:30+00 1 attack 2022-04-05T11:45+00 1...
test-img

d3f2

postgresql

pivot

psql

Votes: 0

Answers: 2

Latest Answer

You can try to use subquery with ROW_NUMER window function which help you make row number by game_id, action_name columns, then you can use condition aggregate function for that rn SELECT game_id,...
test-img

D-Shih

Can't start PostgreSQL on Manjaro 21.2.5

I cannot start PostgreSQL 13.6 on Manjaro 21.2.5 running inside VirtualBox. How to get PostgreSQL to work with Manjaro? I downloaded PostgreSQL using the Manjaro package manager. Thank you!    ~ ...
test-img

johnnybegoode

postgresql

psql

manjaro

Votes: 0

Answers: 1

Latest Answer

Have you initialized the database? initdb --locale $LANG -E UTF8 -D '/var/lib/postgres/data/' You might also need to start the service before running psql through systemctl if you haven't already: su...
test-img

Piotr Ostrowski

Posts

Questions

Blogs

Jobs