PG dump with update

Posted on pią 09 marzec 2018 in postgres • Tagged with tips&tricks

Many times, I need to edit some value in particular row in table. The easiest way is to use pgAdminIII - however I don't use it, I'm addicted to psql.

Consider such table:

maho=# CREATE TABLE example(id SERIAL, vals VARCHAR);
CREATE TABLE
maho=# INSERT INTO example(vals) VALUES('some string …

Continue reading