Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id AE19D9FB2F1 for ; Mon, 15 Jan 2007 07:53:16 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-new, port 10024) with ESMTP id 32557-05 for ; Mon, 15 Jan 2007 07:53:01 -0400 (AST) X-Greylist: delayed 00:06:38.955277 by SQLgrey-1.7.4 Received: from sapo.pt (relay1.ptmail.sapo.pt [212.55.154.21]) by postgresql.org (Postfix) with SMTP id 447CF9FB2EF for ; Mon, 15 Jan 2007 07:53:04 -0400 (AST) Received: (qmail 10289 invoked from network); 15 Jan 2007 11:46:23 -0000 Received: from unknown (HELO sapo.pt) (10.134.35.205) by relay1 with SMTP; 15 Jan 2007 11:46:23 -0000 Received: (qmail 9902 invoked from network); 15 Jan 2007 11:46:24 -0000 X-AntiVirus: PTMail-AV 0.3-0.88.6 X-Virus-Status: Clean (0.01403 seconds) Received: from unknown (HELO hmv02) (hmv@[82.155.152.54]) (envelope-sender ) by mta10 (qmail-ldap-1.03) with SMTP for ; 15 Jan 2007 11:46:24 -0000 Message-ID: <002c01c7389a$cba58590$6200a8c0@hmv02> From: =?iso-8859-1?Q?H=E9lder_M._Vieira?= To: Subject: Pg_dump behaviour Date: Mon, 15 Jan 2007 11:46:29 -0000 MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original Content-Transfer-Encoding: 8bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.3028 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200701/121 X-Sequence-Number: 24277 I often perform single-table backups using pgadmin. Recently, a problem occurred while doing that kind of backup using pgadmin 1.6.2 and PostgreSQL 8.2.1 on a Windows server: When trying to backup a table contained in a specific schema, pg_dump can't find the table. For instance, I have a database named 'mdg', containing a schema named 'art', in turn containing a table named 'tefh'. When I try to backup this table to the root directory with pgadmin, it generates and executes the following command: pg_dump.exe -i -h localhost -p 5432 -U postgres -F c -v -f "c:\tefh" -t tefh -n art mdg Pg_dump then raises the following error: pg_dump: No matching tables were found I tried some alternatives from the command line, but pg_dump only seems to make the single-table backup when the table name is qualified, as in: pg_dump.exe -i -h localhost -p 5432 -U postgres -F c -v -f "c:\tefh" -t art.tefh mdg At this point, I'd say that the command generated by pgadmin should work, as it seems to be consistent with pg_dump documentation. Any hints ? Thank you. Hélder M. Vieira