some may have already done this one.
i need to manipulate backup(sql file) to delete the insert statement where userid=user1
the SQL file contains...
- Code: Select all
--
-- PostgreSQL database dump
--
SET statement_timeout = 0;
SET search_path = public, pg_catalog;
--
-- Data for Name: address; Type: TABLE DATA; Schema: public; Owner: postgres
--
INSERT INTO address (idaddress, street, city, userid) VALUES (1, '199 Essex Street', 'Epping', 'user1');
INSERT INTO address (idaddress, street, city, userid) VALUES (2, '200 Essex Street', 'Epping', 'user2');
thanks!