pg_restore -t table concerns
От | Mike Toews |
---|---|
Тема | pg_restore -t table concerns |
Дата | |
Msg-id | 4A48F765.4000806@sfu.ca обсуждение исходный текст |
Ответы |
Re: pg_restore -t table concerns
|
Список | pgsql-hackers |
Hey hackers, I have a few concerns with the usability and documentation for pg_restore (note: I'm on 8.3, but I've checked the documentation for 8.4). In my attempts to restore a table (using -t) from a backup file with -v (verbose) selected, I noticed a few things: 1. If a non-existent table is used, e.g., "-t idontexist" no warnings are thrown. (It took me a while to figure outwhy a table was not being restored, since no warnings were issued.) 2. It appears that the -t (table) option doesnot allow full table names, such as "myschema.mytable", however this is not stated in the documentation for -ttable. Is it possible to allow -t table to accept [schema.]table qualifiers? If not, the documentation should atleast suggest that "-n namespace" be used to specify the schema where the table resides. 3. It appears the the defaultfor -n namespace uses the default_path variable (typically "public"). However, I'm only guessing this basedon the behaviour, and it isn't mentioned in the documentation for -n namespace. Thanks for any input, and apologies if this has already been discussed. -Mike
В списке pgsql-hackers по дате отправления: