>I knw that I have to use include instead of excluding the tables.Do I have to include each and >>every tables manually or is there way to do that?
There's no guarantee. but the following query might be a good starting point to build your include list. It selects only tables with less than 3000 tuples (naturally you will change the value to suit your needs. Note that per the documenatation: "This is only an estimate used by the planner. It is updated by VACUUM, ANALYZE, and a few DDL commands such as CREATE INDEX." So a FULL VACUUM is advised before executing. SELECT n.nspname || ' .' || c.relname AS tablename FROM pg_class c LEFT JOIN pg_namespace n ON n.oid = c.relnamespace LEFT JOIN pg_tablespace t ON t.oid = c.reltablespace WHERE c.relkind = 'r'::"char" AND reltuples < 3000 ORDER BY n.nspname; Melvin Davidson Database Developer Computer & Communication Technologies, Inc. 6 Inverness Court East, Suite 220 Englewood, CO 80112
BEGIN:VCARD VERSION:2.1 N:Davidson;Melvin FN:Melvin Davidson ORG:CCT TEL;WORK;VOICE:303-708-9228x305 ADR;WORK;ENCODING=QUOTED-PRINTABLE:;;6 Inverness Ct East=0D=0ASuite 220;Englewood;CO;80112;United States LABEL;WORK;ENCODING=QUOTED-PRINTABLE:6 Inverness Ct East=0D=0ASuite 220=0D=0AEnglewood, CO 80112=0D=0AUnited Stat= es EMAIL;PREF;INTERNET:[EMAIL PROTECTED] REV:20060518T221645Z END:VCARD
---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly