I have a database schema named: nyummy
and a table named cimory
:
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)
);
I want to export the cimory
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).
How to do it?
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.