postgresqlpgadmin-4unique-key
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
- PostgreSQL: Modify OWNER on all tables simultaneously in PostgreSQL
- Postgresql autocomplete?
- SQL query to fetch persons with more than one postcode address via join table
- docker tmpfs seems to have no effect on postgresql
- ERROR: extra data after last expected column on postgresql
- Grouping rows by day in unixtime
- Select only distinct values from two tables on pgadmin without getting all combinations
- Performance loss introducing lateral join in Postgres query
- Is it possible to create a procedure with ANALYZE table instruction?
- Efficiently storing data that is partially columnar into a DuckDB database in a purely columnar form
- is there any way to write test cases for repositories in spring boot without using H2 daatabase?
- Error : relation "OutboxState" does not exist
- copying 3 columns from a 4 column table with multiple CONFLICT conditions
- Using pg_notify in PostgreSQL trigger function
- postgres: using previous row value when current row value is null
- EF Core one-to-one relation returns one-to-many relation
- Storing and managing Forex trading tick data
- Possible bug with PHP PDO and with PostgreSQL
- Error while loading shared libraries: libpq.so.5
- Duckdb sql and postgres results differ when using unnest
- How to connect to localhost with postgres_fdw?
- Python 3.10.6 alembic postgresql password with special character
- Using SQLAlchemy sessions with flask & concurrency problems
- How to reload PostgreSQL configuration
- How to show tables in PostgreSQL?
- How can I change a PostgreSQL user password?
- postgres- plsql function to get rows counts for specific columns with null data
- SQLAlchemy - Get query results in same order as IN clause
- Strange sorting behavior with bigint column via GiST index in PostgreSQL
- Laravel and PHP8.3 can't connect to Postgre database