title: Export specific rows from a PostgreSQL table as INSERT SQL script
body: <p>I have a database schema named: <code>nyummy</code> and a table named <code>cimory</code>:</p>
  
  <pre><code>create table nyummy.cimory (
    id numeric(10,0) not null,
    name character varying(60) not null,
    city character varying(50) not null,
    CONSTRAINT cimory_pkey PRIMARY KEY (id)
  );
  </code></pre>
  
  <p>I want to export the <code>cimory</code> table's data as insert SQL script file. However, I only want to export records/data where the city is equal to 'tokyo' (assume city data are all lowercase).</p>
  
  <p>How to do it? </p>
  
  <p>It doesn't matter whether the solution is in freeware GUI tools or command line (although GUI tools solution is better). I had tried pgAdmin III, but I can't find an option to do this.</p>