I have a Postgres table that looks like this: Name Type Description business_id (PK) int4 Business ID day (PK) int4 Day of week (0-6, monday is zero) open time Open time close time Close time Every row stores open and…
I need to copy all data from one column customerId to another new column (customerIds - which is in different format) in the same table. There is a column called customerId whose type is bigint and I need to copy…
I am unable to delete PostgreSQL database in azure using the below command: az PostgreSQL db delete Is there any other script such as bash to clean up azure postgreSQL database?
I have table towns which is main table. This table contains so many rows and it became so 'dirty' (someone inserted 5 milions rows) that I would like to get rid of unused towns. There are 3 referent table that…
I am trying to run migrations in my go-fiber rest API using golang-migrate. I added the commands for running the migrations in a makefile. However, when I run make migrateup, I get the following error: migrate -path database/postgres/migrations -database "postgresql://postgres:postgres@localhost:5400/property?sslmode=disable"…
I need to join all the three tables as mentioned below datatype id code 1 Q_1 2 Q_2 3 Q_3 4 Q_4 5 Q_5 6 Q_6 7 Q_7 8 Q_8 9 Q_9 10 Q_10 model id datatype_id values model_ex_id 1…
We created several views postgresql 12 (not materialized views) which include nested queries and multiple joins. we are facing a strange behavior, are noticing that some views are disappearing from the view list and others are remaining. is this related…
Seemingly similar to How to get the top 10 values in postgresql?, yet somehow very different. We'll set it up similar to that question: I have a postgresql table: Scores(score integer). How would I get the highest 99% of the…
I am doing pg_dump using - pg_dump -U <username> -h <host> <database> > backup.sql pg_dump is working fine. I am trying to do pg_restore doing - pg_restore -U <username> -h <host> -d <databse> backup.sql Then it is showing pg_restore: error:…
The PostgreSQL database is just installed directly into the linux host machine (not as docker container). In a docker container (built with docker compose) I have an application that needs to connect to the database. The client container needs to…