blocks|key|460263|text|使用要导出的集合创建一个表格，然后使用命令行实用程序pg_dump将其导出到文件：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|460264|create+table+export_table+as+
select+id,+name,+city
from+nyummy.cimory
where+city+=+'tokyo'|code-block|syntax|javascript|460265|$+pg_dump+--table=export_table+--data-only+--column-inserts+my_database+>+data.sql|460266|--column-inserts将转储为带有列名的insert命令。|offset|length|style|CODE|460267|--data-only不转储架构。|460268|如下所述，在中创建视图而不是表将在需要新导出时避免创建表。|460269|entityMap^0|0|0|0|0|G|0|0|B|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|V|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|D|7|W|8|@]|9|@]|A|$E|F]]|$1|I|3|J|5|6|7|X|8|@$K|Y|L|Z|M|N]]|9|@]|A|$]]|$1|O|3|P|5|6|7|10|8|@$K|11|L|12|M|N]]|9|@]|A|$]]|$1|Q|3|R|5|6|7|13|8|@]|9|@]|A|$]]|$1|S|3|-4|5|6|7|14|8|@]|9|@]|A|$]]]|T|$]]

Create a table with the set you want to export and then use the command line utility pg_dump to export to a file:

<pre><code>create table export_table as 
select id, name, city
from nyummy.cimory
where city = 'tokyo'
</code></pre>

<pre class="lang-sh prettyprint-override"><code>$ pg_dump --table=export_table --data-only --column-inserts my_database &gt; data.sql
</code></pre>

<code>--column-inserts</code> will dump as insert commands with column names.

<code>--data-only</code> do not dump schema.

As commented below, creating a view in instead of a table will obviate the table creation whenever a new export is necessary.

blocks|key|243441|text|对于我的用例，我能够简单地通过管道连接到grep。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|243442|pg_dump+-U+user_name+--data-only+--column-inserts+-t+nyummy.cimory+%7C+grep+"tokyo"+>+tokyo.sql|code-block|syntax|javascript|243443|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

For my use-case I was able to simply pipe to grep.

<pre><code>pg_dump -U user_name --data-only --column-inserts -t nyummy.cimory | grep "tokyo" &gt; tokyo.sql
</code></pre>

blocks|key|460319|text|SQL+Workbench就有这样一个特性。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|460320|运行查询后，右键单击查询结果并选择"Copy+Data+As+SQL+>+SQL+Insert“|460321|entityMap|0|LINK|mutability|MUTABLE|url|http://www.sql-workbench.net/^0|0|D|0|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@$A|O|B|P|1|Q]]|C|$]]|$1|D|3|E|5|6|7|R|8|@]|9|@]|C|$]]|$1|F|3|-4|5|6|7|S|8|@]|9|@]|C|$]]]|G|$H|$5|I|J|K|C|$L|M]]]]

<a href="http://www.sql-workbench.net/">SQL Workbench</a> has such a feature.

After running a query, right click on the query results and choose "Copy Data As SQL > SQL Insert"

blocks|key|460469|text|我试着基于@PhilHibbs代码，以一种不同的方式编写了一个这样做的过程。请看一看并测试一下。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|460470|+CREATE+OR+REPLACE+FUNCTION+dump(IN+p_schema+text,+IN+p_table+text,+IN+p_where+text)
+++RETURNS+setof+text+AS
+$BODY$
+DECLARE
+++++dumpquery_0+text;
+++++dumpquery_1+text;
+++++selquery+text;
+++++selvalue+text;
+++++valrec+record;
+++++colrec+record;
+BEGIN

+++++--+------+--
+++++--+GLOBAL+--
+++++--+++build+base+INSERT
+++++--+++build+SELECT+array[+...+]
+++++dumpquery_0+:=+'INSERT+INTO+'+%7C%7C++quote_ident(p_schema)+%7C%7C+'.'+%7C%7C+quote_ident(p_table)+%7C%7C+'(';
+++++selquery++++:=+'SELECT+array[';

+++++<<label0>>
+++++FOR+colrec+IN+SELECT+table_schema,+table_name,+column_name,+data_type
+++++++++++++++++++FROM+information_schema.columns
+++++++++++++++++++WHERE+table_name+=+p_table+and+table_schema+=+p_schema
+++++++++++++++++++ORDER+BY+ordinal_position
+++++LOOP
+++++++++dumpquery_0+:=+dumpquery_0+%7C%7C+quote_ident(colrec.column_name)+%7C%7C+',';
+++++++++selquery++++:=+selquery++++%7C%7C+'CAST('+%7C%7C+quote_ident(colrec.column_name)+%7C%7C+'+AS+TEXT),';
+++++END+LOOP+label0;

+++++dumpquery_0+:=+substring(dumpquery_0+,1,length(dumpquery_0)-1)+%7C%7C+')';
+++++dumpquery_0+:=+dumpquery_0+%7C%7C+'+VALUES+(';
+++++selquery++++:=+substring(selquery++++,1,length(selquery)-1)++++%7C%7C+']+AS+MYARRAY';
+++++selquery++++:=+selquery++++%7C%7C+'+FROM+'+%7C%7Cquote_ident(p_schema)%7C%7C'.'%7C%7Cquote_ident(p_table);
+++++selquery++++:=+selquery++++%7C%7C+'+WHERE+'%7C%7Cp_where;
+++++--+GLOBAL+--
+++++--+------+--

+++++--+-----------+--
+++++--+SELECT+LOOP+--
+++++--+++execute+SELECT+built+and+loop+on+each+row
+++++<<label1>>
+++++FOR+valrec+IN++EXECUTE++selquery
+++++LOOP
+++++++++dumpquery_1+:=+'';
+++++++++IF+not+found+THEN
+++++++++++++EXIT+;
+++++++++END+IF;

+++++++++--+-----------+--
+++++++++--+LOOP+ARRAY+(EACH+FIELDS)+--
+++++++++<<label2>>
+++++++++FOREACH+selvalue+in+ARRAY+valrec.MYARRAY
+++++++++LOOP
+++++++++++++IF+selvalue+IS+NULL
+++++++++++++THEN+selvalue+:=+'NULL';
+++++++++++++ELSE+selvalue+:=+quote_literal(selvalue);
+++++++++++++END+IF;
+++++++++++++dumpquery_1+:=+dumpquery_1+%7C%7C+selvalue+%7C%7C+',';
+++++++++END+LOOP+label2;
+++++++++dumpquery_1+:=+substring(dumpquery_1+,1,length(dumpquery_1)-1)+%7C%7C+');';
+++++++++--+LOOP+ARRAY+(EACH+FIELD)+--
+++++++++--+-----------+--

+++++++++--+debug:+RETURN+NEXT+dumpquery_0+%7C%7C+dumpquery_1+%7C%7C+'+--'+%7C%7C+selquery;
+++++++++--+debug:+RETURN+NEXT+selquery;
+++++++++RETURN+NEXT+dumpquery_0+%7C%7C+dumpquery_1;

+++++END+LOOP+label1+;
+++++--+SELECT+LOOP+--
+++++--+-----------+--

+RETURN+;
+END
+$BODY$
+++LANGUAGE+plpgsql+VOLATILE;|code-block|syntax|javascript|460471|然后：|460472|--+for+a+range
SELECT+dump('public',+'my_table','my_id+between+123456+and+123459');+
--+for+the+entire+table
SELECT+dump('public',+'my_table','true');|460473|在我的postgres+9.1上使用混合字段数据类型(文本、双精度、整数、不带时区的时间戳等)的表进行了测试。|460474|这就是为什么需要转换为TEXT类型的原因。我的测试正确运行了大约900万行，看起来它在运行18分钟之前失败了。|460475|ps+:我在网上找到了mysql的等价物。|460476|entityMap^0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|T|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|U|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|V|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|W|8|@]|9|@]|A|$]]|$1|M|3|N|5|6|7|X|8|@]|9|@]|A|$]]|$1|O|3|P|5|6|7|Y|8|@]|9|@]|A|$]]|$1|Q|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]]|R|$]]

I tried to write a procedure doing that, based on @PhilHibbs codes, on a different way.
Please have a look and test.

<pre><code> CREATE OR REPLACE FUNCTION dump(IN p_schema text, IN p_table text, IN p_where text)
 RETURNS setof text AS
 $BODY$
 DECLARE
 dumpquery_0 text;
 dumpquery_1 text;
 selquery text;
 selvalue text;
 valrec record;
 colrec record;
 BEGIN

 -- ------ --
 -- GLOBAL --
 -- build base INSERT
 -- build SELECT array[ ... ]
 dumpquery_0 := 'INSERT INTO ' || quote_ident(p_schema) || '.' || quote_ident(p_table) || '(';
 selquery := 'SELECT array[';

 &lt;&lt;label0&gt;&gt;
 FOR colrec IN SELECT table_schema, table_name, column_name, data_type
 FROM information_schema.columns
 WHERE table_name = p_table and table_schema = p_schema
 ORDER BY ordinal_position
 LOOP
 dumpquery_0 := dumpquery_0 || quote_ident(colrec.column_name) || ',';
 selquery := selquery || 'CAST(' || quote_ident(colrec.column_name) || ' AS TEXT),';
 END LOOP label0;

 dumpquery_0 := substring(dumpquery_0 ,1,length(dumpquery_0)-1) || ')';
 dumpquery_0 := dumpquery_0 || ' VALUES (';
 selquery := substring(selquery ,1,length(selquery)-1) || '] AS MYARRAY';
 selquery := selquery || ' FROM ' ||quote_ident(p_schema)||'.'||quote_ident(p_table);
 selquery := selquery || ' WHERE '||p_where;
 -- GLOBAL --
 -- ------ --

 -- ----------- --
 -- SELECT LOOP --
 -- execute SELECT built and loop on each row
 &lt;&lt;label1&gt;&gt;
 FOR valrec IN EXECUTE selquery
 LOOP
 dumpquery_1 := '';
 IF not found THEN
 EXIT ;
 END IF;

 -- ----------- --
 -- LOOP ARRAY (EACH FIELDS) --
 &lt;&lt;label2&gt;&gt;
 FOREACH selvalue in ARRAY valrec.MYARRAY
 LOOP
 IF selvalue IS NULL
 THEN selvalue := 'NULL';
 ELSE selvalue := quote_literal(selvalue);
 END IF;
 dumpquery_1 := dumpquery_1 || selvalue || ',';
 END LOOP label2;
 dumpquery_1 := substring(dumpquery_1 ,1,length(dumpquery_1)-1) || ');';
 -- LOOP ARRAY (EACH FIELD) --
 -- ----------- --

 -- debug: RETURN NEXT dumpquery_0 || dumpquery_1 || ' --' || selquery;
 -- debug: RETURN NEXT selquery;
 RETURN NEXT dumpquery_0 || dumpquery_1;

 END LOOP label1 ;
 -- SELECT LOOP --
 -- ----------- --

 RETURN ;
 END
 $BODY$
 LANGUAGE plpgsql VOLATILE;
</code></pre>

And then :

<pre><code>-- for a range
SELECT dump('public', 'my_table','my_id between 123456 and 123459'); 
-- for the entire table
SELECT dump('public', 'my_table','true');
</code></pre>

tested on my postgres 9.1, with a table with mixed field datatype (text, double, int,timestamp without time zone, etc).

That's why the CAST in TEXT type is needed.
My test run correctly for about 9M lines, looks like it fail just before 18 minutes of running.

ps : I found an equivalent for mysql on the WEB.

blocks|key|460196|text|您可以查看包含特定记录的表，然后转储sql文件|type|unstyled|depth|inlineStyleRanges|entityRanges|data|460197|CREATE+VIEW+foo+AS
SELECT+id,name,city+FROM+nyummy.cimory+WHERE+city+=+'tokyo'|code-block|syntax|javascript|460198|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

You can make view of the table with specifit records and then dump sql file

<pre><code>CREATE VIEW foo AS
SELECT id,name,city FROM nyummy.cimory WHERE city = 'tokyo'
</code></pre>

blocks|key|460424|text|我只是做了一个快速的程序来做这件事。它只适用于单行，所以我创建了一个临时视图，它只选择我想要插入的行，然后用我想要插入到其中的实际表替换pg_temp.temp_view。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|460425|CREATE+OR+REPLACE+FUNCTION+dv_util.gen_insert_statement(IN+p_schema+text,+IN+p_table+text)
++RETURNS+text+AS
$BODY$
DECLARE
++++selquery+text;+
++++valquery+text;+
++++selvalue+text;+
++++colvalue+text;+
++++colrec+record;
BEGIN

++++selquery+:=+'INSERT+INTO+'+%7C%7C++quote_ident(p_schema)+%7C%7C+'.'+%7C%7C+quote_ident(p_table);

++++selquery+:=+selquery+%7C%7C+'(';

++++valquery+:=+'+VALUES+(';
++++FOR+colrec+IN+SELECT+table_schema,+table_name,+column_name,+data_type
++++++++++++++++++FROM+information_schema.columns+
++++++++++++++++++WHERE+table_name+=+p_table+and+table_schema+=+p_schema+
++++++++++++++++++ORDER+BY+ordinal_position+
++++LOOP
++++++selquery+:=+selquery+%7C%7C+quote_ident(colrec.column_name)+%7C%7C+',';

++++++selvalue+:=+
++++++++'SELECT+CASE+WHEN+'+%7C%7C+quote_ident(colrec.column_name)+%7C%7C+'+IS+NULL'+%7C%7C+
+++++++++++++++++++'+THEN+''NULL'''+%7C%7C+
+++++++++++++++++++'+ELSE+''''+%7C%7C+quote_literal('%7C%7C+quote_ident(colrec.column_name)+%7C%7C+')::text+%7C%7C+'''''+%7C%7C+
+++++++++++++++++++'+END'+%7C%7C+
++++++++'+FROM+'%7C%7Cquote_ident(p_schema)%7C%7C'.'%7C%7Cquote_ident(p_table);
++++++EXECUTE+selvalue+INTO+colvalue;
++++++valquery+:=+valquery+%7C%7C+colvalue+%7C%7C+',';
++++END+LOOP;
++++--+Replace+the+last+,+with+a+)
++++selquery+:=+substring(selquery,1,length(selquery)-1)+%7C%7C+')';
++++valquery+:=+substring(valquery,1,length(valquery)-1)+%7C%7C+')';

++++selquery+:=+selquery+%7C%7C+valquery;

RETURN+selquery;
END
$BODY$
++LANGUAGE+plpgsql+VOLATILE;|code-block|syntax|javascript|460426|这样调用：|460427|SELECT+distinct+dv_util.gen_insert_statement('pg_temp_'+%7C%7C+sess_id::text,'my_data')+
from+pg_stat_activity+
where+procpid+=+pg_backend_pid()|460428|我还没有针对注入攻击进行测试，如果quote_literal调用不足以应对注入攻击，请让我知道。|460429|此外，它只适用于可以简单地转换为::text并返回的列。|460430|这也是针对Greenplum的，但我想不出为什么它不能在Postgres、CMIIW上工作。|460431|entityMap^0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|T|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|U|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|V|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|W|8|@]|9|@]|A|$]]|$1|M|3|N|5|6|7|X|8|@]|9|@]|A|$]]|$1|O|3|P|5|6|7|Y|8|@]|9|@]|A|$]]|$1|Q|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]]|R|$]]

I just knocked up a quick procedure to do this. It only works for a single row, so I create a temporary view that just selects the row I want, and then replace the pg_temp.temp_view with the actual table that I want to insert into.

<pre><code>CREATE OR REPLACE FUNCTION dv_util.gen_insert_statement(IN p_schema text, IN p_table text)
 RETURNS text AS
$BODY$
DECLARE
 selquery text; 
 valquery text; 
 selvalue text; 
 colvalue text; 
 colrec record;
BEGIN

 selquery := 'INSERT INTO ' || quote_ident(p_schema) || '.' || quote_ident(p_table);

 selquery := selquery || '(';

 valquery := ' VALUES (';
 FOR colrec IN SELECT table_schema, table_name, column_name, data_type
 FROM information_schema.columns 
 WHERE table_name = p_table and table_schema = p_schema 
 ORDER BY ordinal_position 
 LOOP
 selquery := selquery || quote_ident(colrec.column_name) || ',';

 selvalue := 
 'SELECT CASE WHEN ' || quote_ident(colrec.column_name) || ' IS NULL' || 
 ' THEN ''NULL''' || 
 ' ELSE '''' || quote_literal('|| quote_ident(colrec.column_name) || ')::text || ''''' || 
 ' END' || 
 ' FROM '||quote_ident(p_schema)||'.'||quote_ident(p_table);
 EXECUTE selvalue INTO colvalue;
 valquery := valquery || colvalue || ',';
 END LOOP;
 -- Replace the last , with a )
 selquery := substring(selquery,1,length(selquery)-1) || ')';
 valquery := substring(valquery,1,length(valquery)-1) || ')';

 selquery := selquery || valquery;

RETURN selquery;
END
$BODY$
 LANGUAGE plpgsql VOLATILE;
</code></pre>

Invoked thus:

<pre><code>SELECT distinct dv_util.gen_insert_statement('pg_temp_' || sess_id::text,'my_data') 
from pg_stat_activity 
where procpid = pg_backend_pid()
</code></pre>

I haven't tested this against injection attacks, please let me know if the quote_literal call isn't sufficient for that.

Also it only works for columns that can be simply cast to ::text and back again.

Also this is for Greenplum but I can't think of a reason why it wouldn't work on Postgres, CMIIW.

blocks|key|243627|text|右键单击数据库，然后单击备份|type|unstyled|depth|inlineStyleRanges|entityRanges|data|243628|​|243629|📷|atomic|offset|length|243630|243631|然后，仅从转储选项部分的数据和查询使用insert命令。|243632|243633|243634|243635|243636|243637|243638|然后格式化"Plain“选择它。|243639|243640|243641|243642|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/39f54aec8d3e0b8f121c2f3889dc86ea.png|imageAlt|1|https://ask.qcloudimg.com/http-save/yehe-900000/04a30f3ad66a778bced2bb1b1fdbd82b.png|2|https://ask.qcloudimg.com/http-save/yehe-900000/105247ab21a014ef1989b7ef287eaa3c.png|3|https://ask.qcloudimg.com/http-save/yehe-900000/2ee24844fb47cae8094e87832afd5624.png^0|0|0|0|1|0|0|0|0|0|0|1|1|0|0|0|0|1|2|0|0|0|0|0|1|3|0|0^^$0|@$1|2|3|4|5|6|7|1B|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|1C|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|1D|8|@]|9|@$G|1E|H|1F|1|1G]]|A|$]]|$1|I|3|C|5|6|7|1H|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|1I|8|@]|9|@]|A|$]]|$1|L|3|C|5|6|7|1J|8|@]|9|@]|A|$]]|$1|M|3|E|5|F|7|1K|8|@]|9|@$G|1L|H|1M|1|1N]]|A|$]]|$1|N|3|C|5|6|7|1O|8|@]|9|@]|A|$]]|$1|O|3|C|5|6|7|1P|8|@]|9|@]|A|$]]|$1|P|3|E|5|F|7|1Q|8|@]|9|@$G|1R|H|1S|1|1T]]|A|$]]|$1|Q|3|C|5|6|7|1U|8|@]|9|@]|A|$]]|$1|R|3|S|5|6|7|1V|8|@]|9|@]|A|$]]|$1|T|3|C|5|6|7|1W|8|@]|9|@]|A|$]]|$1|U|3|E|5|F|7|1X|8|@]|9|@$G|1Y|H|1Z|1|20]]|A|$]]|$1|V|3|C|5|6|7|21|8|@]|9|@]|A|$]]|$1|W|3|-4|5|6|7|22|8|@]|9|@]|A|$]]]|X|$Y|$5|Z|10|11|A|$12|13|14|-4]]|15|$5|Z|10|11|A|$12|16|14|-4]]|17|$5|Z|10|11|A|$12|18|14|-4]]|19|$5|Z|10|11|A|$12|1A|14|-4]]]]

Right click database and click backup
<a href="https://i.stack.imgur.com/3CMwQ.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/3CMwQ.png" alt="enter image description here" /></a>
Then use insert commands from only data and queries from the dump options section.
<a href="https://i.stack.imgur.com/TkAKj.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/TkAKj.png" alt="enter image description here" /></a>
<a href="https://i.stack.imgur.com/dUCE6.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/dUCE6.png" alt="enter image description here" /></a>
Then Format &quot;Plain&quot; chosen just it.
<a href="https://i.stack.imgur.com/1do49.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/1do49.png" alt="enter image description here" /></a>

blocks|key|460229|text|我是否尝试过在pgadmin中使用"+EXECUTE+QUERY+WRITE+RESULT+TO+FILE+"选项执行查询|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|460230|它只导出数据，否则尝试如下所示|460231|pg_dump+-t+view_name+DB_name+>+db.sql|code-block|syntax|javascript|460232|-t选项仅用于==>转储与表匹配的表(或视图或序列)，refer|460233|entityMap|0|LINK|mutability|MUTABLE|url|http://www.postgresql.org/docs/8.3/static/app-pgdump.html^0|H|12|0|0|0|R|5|0|0^^$0|@$1|2|3|4|5|6|7|W|8|@$9|X|A|Y|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|Z|8|@]|D|@]|E|$]]|$1|H|3|I|5|J|7|10|8|@]|D|@]|E|$K|L]]|$1|M|3|N|5|6|7|11|8|@]|D|@$9|12|A|13|1|14]]|E|$]]|$1|O|3|-4|5|6|7|15|8|@]|D|@]|E|$]]]|P|$Q|$5|R|S|T|E|$U|V]]]]

have u tried in pgadmin executing query with <code> " EXECUTE QUERY WRITE RESULT TO FILE " </code>option 

its only export the data, else try like 

<pre><code>pg_dump -t view_name DB_name &gt; db.sql
</code></pre>

-t option used for ==> Dump only tables (or views or sequences) matching table, <a href="http://www.postgresql.org/docs/8.3/static/app-pgdump.html" rel="nofollow">refer</a>

I have a database schema named: <code>nyummy</code> and a table named <code>cimory</code>:

<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>

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).

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.

Export specific rows from a PostgreSQL table as INSERT SQL script

我有一个名为nyummy的数据库模式和一个名为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 

问将PostgreSQL表中的特定行导出为插入SQL脚本
EN

回答 8

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问将PostgreSQL表中的特定行导出为插入SQL脚本EN

回答 8

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问将PostgreSQL表中的特定行导出为插入SQL脚本
EN