ReadMeFeed / Community knowledge
Real questions. Useful conversations. Find the people who know your stack.
The documentation doesn't have examples. https://www.postgresql.org/docs/10/datatype-numeric.html#DATATYPE-NUMERIC-TABLE NUMERIC(precision, scale) I want to use the smallest amount of space to save a positive number that will be at most 100 and I need to accept decimal increments of 0.5 What precision and scale should I use in this case?
I am trying to add a generated column to an existing table with this script. alter table Asset_Store add column md5_hash VARCHAR(100) GENERATED ALWAYS AS (CAST(UPPER( case when OR_ID is not null then MD5(cast(OR_ID as varchar(100))) when Asset_ID is not null then MD5(Asset_ID) else null end ) as VARCHAR(100))) STORED ; but I am getting an error: SQL Error [4
I want to UPDATE or INSERT a column in PostgreSQL instead of doing INSERT or UPDATE using INSERT ... ON CONFLICT ... because there will be more updates than more inserts and also I have an auto incrementing id column that's defined using SERIAL so it increments the id column everytime it tries to INSERT or UPDATE and that's not what I want, I want the id col
Can't create tables in public schema as non-superuser postgres - super user. What I've done: ALTER SCHEMA public owner to postgres; CREATE USER admin WITH PASSWORD 'my-password'; GRANT USAGE, CREATE ON SCHEMA public TO postgres; GRANT USAGE, CREATE ON SCHEMA public TO admin; CREATE DATABASE mydb; GRANT ALL ON DATABASE mydb TO admin; privileges: postgres=# \d
I have a scientific database with currently 4,300,000 records. It's a scientific database, and an API is feeding it. In june 2020, I will probably have about 100,000,000 records. This is de layout of the table 'output': ID | sensor_ID | speed | velocity | direction ----------------------------------------------------- 1 | 1 | 10 | 1 | up 2 | 2 | 12 | 2 | up
So I am setting up PostgreSQL on my PC by following Jose Portilla's Course on Udemy and when I had to restore a database by the name of dvdrental. It showed up the message `Please configure the PostgreSQL Binary Path in the Preferences dialog. What am I supposed to do now? Any and All Help is Appreciated
CREATE TABLE my_app.person ( person_id smallserial NOT NULL, first_name character varying(50), last_name character varying(50), full_name character varying(100) generated always as (concat(first_name, ' ', last_name)) STORED, birth_date date, created_timestamp timestamp default current_timestamp, PRIMARY KEY (person_id) ); Error: generation expression is not
I want to create an enum column in a Supabase table. Supabase uses Postgres under the hood, so I understand that technically it is possible if I do it manually using SQL. But is there any way I can do it via the frontend in an easier manner?
I often just want to test out a function, or see what a variable might look like. This could be done by creating a temporary table, but I suspect that there is an easier way. Basically, WITH cte1 AS ( SELECT VALUES(1,2,3) AS temp_var1 , VALUES(4,5,6) AS temp_var2 ) SELECT temp_var1 , temp_var2 , (temp_var1 + temp_var2) AS temp_var3 FROM cte1 This would retur
postgresql
supabase