I am creating a table in Postgresql, this DDL is the result of a script that I am making to compare bancos. CREATE TABLE projeto_modelo.exemplo_fk1 ( id SERIAL NOT NULL, nome varchar(30) NOT NULL, criado_em timestamp NOT NULL, id_exmp_fk2 int4…
I want to have a case-insensitive unique key on a large table. I'm looking for the fastest approach. I found two options: my_table_a with a generated column and my_table_b with a unique index CREATE TABLE my_table_a ( my_table_id_a int GENERATED…
i have the following tables: tenants: tenantId (UUID) invoiceAddress (TEXT) packages: packageId needsInvoice tenants_and_packages: tenantsAndPackagesId tenantId packageId This is a M2N-Mapping between Tenants and Packages. What is the problem? I want to achieve the following "Check"-Logic. I want to make…
I am making a screen that has a shelf image along with a plus icon overlaying the entire image with a dotted border. I want to make the dotted border take up the entire space allowed by the largest child…
In PostgreSQL, I am not sure I understand after-triggers: Within an AFTER insert or update FOR EACH STATEMENT trigger (function), is it correct that (contrary to e.g. MSSQL), if I query the trigger's table, I see the data before any…
I have a table companies in which there are some duplicated rows I found with a simple GROUP BY name. This companies table has a PRIMARY KEY id which is referenced in several other tables, under the name company_id, which…
I have a log table that tracks updates, structured like this: CREATE TABLE user_log ( name_id VARCHAR, modified DATE, -- Other fields... ); I aim to implement a unique constraint based on the name_id, ensuring that only the most recent…
I am new to Flutter, coming from React and Vue. I'm trying to make a simple widget used to enter hours and minutes. I think it is turning out fine, although I have the problem that the widget stretches out…
I have a users table in my Postgres database with a role column that uses an enum. The user can either be a CAPTAIN or PLAYER. DROP TYPE IF EXISTS USER_ROLE CASCADE; CREATE TYPE USER_ROLE AS ENUM ('CAPTAIN', 'PLAYER'); CREATE…
According to tests both SQL give the same result. alter table public.company add constraint company_name_key unique ("name") vs. alter table public.company add unique ("name"); PostgreSQL (ver. 12.16)