| From: | Miriam Fernández Galicia <msenseif(at)servidor(dot)unam(dot)mx> |
|---|---|
| To: | Guillaume LELARGE <gleu(at)wanadoo(dot)fr> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: backup a table |
| Date: | 2003-06-11 21:52:59 |
| Message-ID: | 1055368378.26130.74.camel@tauri.dgsca.unam.mx |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Thank you Guillaume !! :)
It works!!
Miriam
El mié, 11 de 06 de 2003 a las 18:19, Guillaume LELARGE escribió:
> Hi,
>
> Le Mercredi 11 Juin 2003 20:25, vous avez écrit :
> > Hello!!!
> > I 'm new in Postgres 7.2 my question is, exists some way to backup only
> > a table and no the all database with pg_dump or another utility, too
>
> pg_dump allows you to do this using the -t switch.
> Try something like
> pg_dump -t mytable mydbname
>
> You should probably redirect stdout to some file like this:
> pg_dump -t mytable mydbname > myfile
>
> If you need to specify your user, try something like this one:
> pg_dump -U myuser -t mytable mydbname
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Guillaume LELARGE | 2003-06-11 23:19:36 | Re: backup a table |
| Previous Message | Miriam Fernández Galicia | 2003-06-11 20:25:03 | backup a table |