I need to alter the Data Type of a named column (let's call them 'photo') across all the tables in a schema. For example: I have 300 tables with identical structure (except the data in each row of course). But…
I have a student list table. In the table, there is a column to display study programs. This column retrieves data from the study program database. However, what is displayed in the table is the study program id. What I…
I am trying to create a table and columns in the table and then insert data in the columns. I'm using pgadmin4. This is my query: INSERT INTO moon (ID, NAME, Age, Salary) VALUES (2, 'saqib', 4, 400) Error message:…
I need to estimate the size in GB of a table in a PostgreSQL database. I don't have the database yet (I need the estimate for cost projection purposes). The schema of the table will be: One column containing a…
The database used is PostgreSQL. I have a query that combines two tables and does a where search on some category and then does order by by some property. The table products has a 10+ million products. If I put…
I have a Subject class and a Course class. They are in a many-to-many relationship so I also have a CourseSubject class with navigation properties and id properties to the other two classes. I can now read subjects and courses…
I am creating an webshop app. I have a tech shop with products that are for example CPUs, GPUs, keyboards, mouses etc. All of them have common attributes - id, description, name, but also their own, custom attributes - mouses…
I would like to update values in one postgres table from values in another postgres table, but I would like to update only values which NEED to be updated - ie if a value is already correct, leave it alone…
(I had originally asked this question on the DBA StackExchange, but didn't get much activity in it). In my DB, I have tables for items and connections between them, creating a likely sparse graph, with islands: CREATE TABLE IF NOT…
I can't access my postgresql datatabase because I forgot my password for PostgresSQL super user. What do I need to do? I must enter pass when try to uninstall PostgresSQL or open psql database in terminal.