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

pg_restore options issues

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org>
Subject: pg_restore options issues
Date: 2001-01-06 21:05:08
Message-ID: Pine.LNX.4.30.0101062148240.755-100000@peter.localdomain (view raw or flat)
Thread:
Lists: pgsql-hackers
pg_restore has some options that are supposed to allow restoring some or
all indexes/tables/triggers/etc.  For example

pg_restore --table

restores all tables and

pg_restore --table=my_table

restores only the named table.  The equivalent short option is -t but it
does not allow restoring all tables, since it requires an argument.  I
suggest that an argument of '*' also means to restore all tables.

Also, if you just call pg_restore without arguments it hangs waiting for
input from stdin.  This is a bit confusing.  I suggest that stdin is used
if and only if the file name argument is '-'.

-- 
Peter Eisentraut      peter_e(at)gmx(dot)net       http://yi.org/peter-e/


Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2001-01-06 21:07:33
Subject: Re: global/pg_database ?
Previous:From: Tom LaneDate: 2001-01-06 20:41:59
Subject: Re: global/pg_database ?

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