You are viewing a plain text version of this content. The canonical link for it is here.

Posted to ddlutils-user@db.apache.org by Laurent ROCHE <la...@yahoo.com> on 2007/09/17 14:35:03 UTC

schema and table names

Hi all,

I am using the Ant task of Ddl-Utils 1.0 with PostgreSQL 8.1.9 !

Is there an easy way to extract data only from a set of tables ?
I am trying to extract data from only a defined set of tables. So far, I have only found a way using different schemas ... which is not really convenient as I have to split the tables in as many schemas as needed extractions (and hope they don't have common tables).

 
Have fun,
L@u
The Computing Froggy




      _____________________________________________________________________________ 
Ne gardez plus qu'une seule adresse mail ! Copiez vos mails vers Yahoo! Mail

Re: schema and table names

Posted by Thomas Dudziak <to...@gmail.com>.

On 9/17/07, Laurent ROCHE <la...@yahoo.com> wrote:

> I am using the Ant task of Ddl-Utils 1.0 with PostgreSQL 8.1.9 !
>
> Is there an easy way to extract data only from a set of tables ?
> I am trying to extract data from only a defined set of tables. So far, I have only found a way using different schemas ... which is not really convenient as I have to split the tables in as many schemas as needed extractions (and hope they don't have common tables).

Not with the Ant task, at least not at the moment, but there is an
open issue for this
(http://issues.apache.org/jira/browse/DDLUTILS-87).
If you're not tied to using Ant tasks, then with a few lines of code
you can achieve this. Basically read the model from the database and
then remove all tables from the Database object that you don't need.
After that, use the adjusted model with the DatabaseDataIO class.

Tom