我有一个数据库,有数百张表格,我需要做的是出口特定的表格,并插入数据表,以备一个目录。
我所知道的唯一能做到这一点的说法是
pg_dump -D -a -t zones_seq interway > /tmp/zones_seq.sql
如果我每张桌上都有这一说法,或者能够用类似的话把所有选定的表格出口到一个大片面。 上面的pg_dump并不仅仅出口表的表象。
Any help will be appreciated.
Right from the manual :“Multiple table can be selected by written multi-tchangees
因此,你需要列出所有表格。
pg_dump --column-inserts -a -t zones_seq -t interway -t table_3 ... > /tmp/zones_seq.sql
请注意,如果您有几张表格,附着相同的序号(或颜色),你也可以使用野心,用<代码>-t参数选定:
“Also, 表格参数按照psql s dtor所用的相同规则被解释为一种模式
If those specific tables match a particular pattern, you can use that with the -t option in pg_dump.
pg_dump -D -a -t zones_seq -t interway -t "<pattern>" -f /tmp/zones_seq.sql <DBNAME>
例如,从“测试”开始的倾销表可以使用
pg_dump -D -a -t zones_seq -t interway -t "^test*" -f /tmp/zones_seq.sql <DBNAME>
我如何将Excel板的数据输入我的Django应用? I m将PosgreSQL数据库作为数据库。
On production our database is a few hundred gigabytes in size. For development and testing, we need to create snapshots of this database that are functionally equivalent, but which are only 10 or 20 ...
I ll take the simplest of the SQL functions as an example: CREATE OR REPLACE FUNCTION skater_name_match(INTEGER,VARCHAR) RETURNS BOOL AS $$ SELECT $1 IN (SELECT skaters_skater.competitor_ptr_id ...
I m 在当地网络上运行几台机器,在Salgresql8.3处撰写一份申请。
I want to join few attributes in select statement as one for example select id, (name + + surname + + age) as info from users this doesn t work, how to do it? I m using postgreSQL.
Hey, I have 2 tables in PostgreSql: 1 - documents: id, title 2 - updates: id, document_id, date and some data: documents: | 1 | Test Title | updates: | 1 | 1 | 2006-01-01 | | 2 | 1 | 2007-01-01 |...
I need to setup my PostgreSQL DB s text encoding to handle non-American English characters that you d find showing up in languages such as German, Spanish, and French. What character encoding should ...
I am using a set of SQL LIKE conditions to go through the alphabet and list all items beginning with the appropriate letter, e.g. to get all books where the title starts with the letter "A": SELECT * ...