From: | koffi BADOH <koff10(at)hotmail(dot)com> |
---|---|
To: | Caesar Kennedy Olima <caesar(dot)olima(at)gmail(dot)com> |
Cc: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: Dumping multiple tables with pg_admin: I'm wrong |
Date: | 2015-09-03 14:50:42 |
Message-ID: | DUB110-W1275D2D319259413FAAA456CA680@phx.gbl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi ALL,
Sorry , In fact pg_admin can select and dump tables easily.
my posting is a mistake . Apologize.
Thanks again.
koff
Date: Thu, 3 Sep 2015 17:36:09 +0300
Subject: Re: [ADMIN] Dumping multiple tables with pg_admin
From: caesar(dot)olima(at)gmail(dot)com
To: koff10(at)hotmail(dot)com
CC: pgsql-admin(at)postgresql(dot)org
Hi Koff,
Do you mean pg_admin or pg_dump, or is it pgAdmin tool you are enquiring about. If you would like to dump selected tables from either a script or from the shell, then with pg_dump you have a -t (--table) option which you can can use to specify the tables you would like to dump or alternatively -T (--exclude-table) to select the table you would like to exclude from a dump. Hope that helps.
Regards,
Caesar
On 3 September 2015 at 16:42, koffi BADOH <koff10(at)hotmail(dot)com> wrote:
Hi All,
I've just realized that I can't dump once all selected tables with pg_admin . is it true. ? I can't belive.
Does anyone has this issue ?
Of course I know I can dump the whole schema but that is not the matter.
Thanks for all.
koff
From | Date | Subject | |
---|---|---|---|
Next Message | xujian | 2015-09-04 19:23:54 | Kerberos connection question |
Previous Message | Porwal, Utkarsh | 2015-09-03 14:45:09 | Re: PostgresDB - Advise on possible data corruption |