postgresql Archives - Page 9 of 21

PostgreSQL create table if not exists

In a MySQL script you can write: CREATE TABLE IF NOT EXISTS foo ...; … other stuff … and then you can run ...

May 22, 2022
0 Comments

How to add an auto-incrementing primary key to an existing table, in PostgreSQL?

I have a table with existing data. Is there a way to add a primary key without deleting and re-creating the table? 5 ...

May 22, 2022
0 Comments

How to change owner of PostgreSql database?

I need to change the owner of PostgreSql database. How to change owner of PostgreSql database in phppgadmin? 2 Answers 2

May 21, 2022
0 Comments

How to select a schema in postgres when using psql?

I have a postgres database with multiple schemas. When I connect to the database from a shell with psql and I run \dt ...

May 21, 2022
0 Comments

I forgot the password I entered during postgres installation

I either forgot or mistyped (during the installation) the password to the default user of Postgres. I can’t seem to be able to ...

May 21, 2022
0 Comments

How to stop/kill a query in postgresql? [duplicate]

This question already has answers here: Terminate hung query (idle in transaction) (4 answers) Closed 6 years ago. This question is while postmaster ...

May 21, 2022
0 Comments

How to use RETURNING with ON CONFLICT in PostgreSQL?

I have the following UPSERT in PostgreSQL 9.5: INSERT INTO chats ("user", "contact", "name") VALUES ($1, $2, $3), ($2, $1, NULL) ON CONFLICT("user", ...

May 21, 2022
0 Comments

Correct way to install psql without full Postgres on macOS?

Official page do not mention such case. But many users need only psql without a local database (I have it on AWS). Brew ...

May 21, 2022
0 Comments

Postgresql – unable to drop database because of some auto connections to DB

Whenever I try to drop database I get: ERROR: database "pilot" is being accessed by other users DETAIL: There is 1 other session ...

May 21, 2022
0 Comments

PostgreSQL delete with inner join

DELETE B.* FROM m_productprice B INNER JOIN m_product C ON B.m_product_id = C.m_product_id WHERE C.upc="7094" AND B.m_pricelist_version_id = '1000020' i am getting the ...

May 21, 2022
0 Comments