Rikesh and list, On Thu, Feb 15, 2024, 18:40 Rikesh Lad via QGIS-User < [email protected]> wrote:
> Hello, > > Please see attached. Does anyone know how to add a primary key and spatial > index to a large layer without the software crashing? > > [image: image.png] > Here is some reference info about adding a primary key to a PostgreSQL table https://www.postgresqltutorial.com/postgresql-tutorial/postgresql-primary-key/#:~:text=To%20add%20a%20primary%20key%20to%20an%20existing%20table%2C%20you,to%20the%20primary%20key%20constraint . > > Here is some reference info that explains how to add a spatial index https://postgis.net/workshops/postgis-intro/indexing.html > Both require the use of a PostgreSQL client for example "psql". > >
_______________________________________________ QGIS-User mailing list [email protected] List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
