To add autoincrement value to table you can use this:
ALTER TABLE public.”Uzytkownicy” ADD COLUMN id BIGSERIAL PRIMARY KEY;
If you have values that are on the table, the unique value of ID will be added automatically.
How to add autoincrement pk to table in pgAdmin?
Categories:
Related Post
Linux błąd filtru i pytania o hasło drukarki – naprawa.Linux błąd filtru i pytania o hasło drukarki – naprawa.
Dziś po upgradzie do Ubuntu 16.04 moja drukarka odmówiła posłuszeństwa, a co gorsza w panelu z drukarkami jestem ciągle atakowany o podanie hasła więc postanowiłem po wielu nieudanych próbach podawania
Redirect location/folder on nginx.Redirect location/folder on nginx.
To redirect folder on nginx you cane add to the configuration file this lines: nano /etc/nginx/sites-available/default location ~ /<strong>folder-name</strong>/(.*)$ { rewrite ^/<strong>folder-name</strong>/(.*)$ /new-name/$1 permanent; } to redirect location on nginx:
Copy large files in LinuxCopy large files in Linux
If you have fault „file is to large” you can use following command: buffer -i /mnt/disk/image.img -o /home/user/image.img -m 5000000 the -m value is buffer size. I’ve got this problem