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 -- Guillaume. ---------------------------(end of broadcast)--------------------------- TIP 3: 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