Skip site navigation (1) Skip section navigation (2)

pg_dump table schema ... not worling ?

From: Hervé Piedvache <herve(at)elma(dot)fr>
To: pgsql-admin(at)postgresql(dot)org
Subject: pg_dump table schema ... not worling ?
Date: 2003-11-27 13:29:12
Message-ID: 200311271429.12417.herve@elma.fr (view raw or flat)
Thread:
Lists: pgsql-admin
Hi,

I would like to get the structures of all my tables m4_clients, m4_contacts 
etc.

Help of pg_dump says :
  -t, --table=TABLE        dump this table only (* for all)

I have tried a :
pg_dump -U postgres -s --table=m4_* my_database
It's not give me any result ...

Neither than : (as the help says !? or I missed understand)
pg_dump -U postgres -s --table=* my_database

It's running only if I'm doing a :
pg_dump -U postgres -s --table=m4_clients my_database

Any idea for help ?

PostgreSQL v7.3.4 used !

Thanks !

Regards,
-- 
Hervé Piedvache

Elma Ingénierie Informatique
6 rue du Faubourg Saint-Honoré
F-75008 - Paris - France
Pho. 33-144949901
Fax. 33-144949902


pgsql-admin by date

Next:From: owDate: 2003-11-27 14:18:47
Subject: Re: "uncompressing" pg_dump file created with --format=c
Previous:From: owDate: 2003-11-27 11:00:07
Subject: "uncompressing" pg_dump file created with --format=c

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group