how to add unique key constraint on column in table in ERD tool in pgAdmin4
I am creating a schema diagram using the ERD tool and want to add a unique key constraint in my column but it seems there is only not null and primary key option is there any idea how to add it?
how to add unique key to the column pan_number and adhare_number in this diagram?
Solution
pgAdmin dev here. Currently, it is not available. A ticket is raised - https://redmine.postgresql.org/issues/7092 and will be available in future release.
Update: This will be available in pgAdmin 6.8
- How to scan into nested structs with sqlx?
- Allow IPs with TCP Listener using RBAC (Envoy)
- Postgres: Add constraint if it doesn't already exist
- UPDATE Statement ignores INNER JOIN
- Change default schema for user
- How to user "smart query conditions" in MikroORM in many-to-many relations #6250
- I want to insert with mikro-orm, but it dont find my table :c (TableNotFoundException)
- PostGIS Installation "could not open extension control file"
- Insert missing rows in time series consumption history
- Why do I received a "invalid byte sequence " when calling a function through pg_background (encoding WIN1252)?
- Entity Framework Core : check if comma-separated string contains any value from list
- How to autofill a field with data from another field in the same table?
- Installing pg -v 1.2.3 using ARCHFLAGS on mac chip
- Conditional PostgreSQL foreign key
- Why is there no rows for 'SHOW config_file' in PostgreSQL database?
- How to use Django BinaryField to store PNG images in postgres?
- How to create a uint256 in PostgreSQL
- Liquibase and functional index
- Update a JSON property in a text column that contains a JSON object
- How can I ensure efficient partition pruning when using dates from subqueries?
- IIF in postgres
- PostgreSQL CREATE USER - need for single quotes around password, no quotes for username
- PostgreSQL - Find row data size in GB, for each five-year period
- Is there any difference between CTE INSERT+UPDATE in one go versus two different queries
- Dynamically generate columns for crosstab in PostgreSQL
- Access and return result from INSERT INTO in PL/pgSQL function
- Postgres restore tables from a dump into a different schema
- Ruby on Rails / PostgreSQL - Library not loaded error when starting server
- Why does Postgres not use the index when the comparison value is derived from my function?
- Why does database not read from newly inserted data when a single query is doing both write and read?