Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

postgres grep entire database

$ pg_dump --data-only --inserts -U postgres your-db-name > a.tmp
$ grep United a.tmp
INSERT INTO countries VALUES ('US', 'United States');
INSERT INTO countries VALUES ('GB', 'United Kingdom');
Source by stackoverflow.com #
 
PREVIOUS NEXT
Tagged: #postgres #grep #entire #database
ADD COMMENT
Topic
Name
6+3 =