Re: Lost file
| От | Fabrízio de Royes Mello |
|---|---|
| Тема | Re: Lost file |
| Дата | |
| Msg-id | AANLkTimhrySn6JWSuR3AU9pf-+JdktoY8yE+BhpcbQ=w@mail.gmail.com обсуждение исходный текст |
| Ответ на | Lost file (Fábio Gibon - Comex System<gibon@comexsystem.com.br>) |
| Список | pgsql-admin |
2010/10/6 Fábio Gibon - Comex System <gibon@comexsystem.com.br>
Hi everybody,
i lost one file in my file system, it's file reference the one user table (table "x")... Are there some option to recover this table? (without any backup and database isn't archive mode).
Hi Fábio,
If you have no backup I do not see how to recover it, but you can recreate the table (only structure) by querying the system catalog (if it is working of course).
Use a similar query do see some information about the columns of table:
SELECT * FROM information_schema.columns WHERE table_name = 'x';
To more information about system catalog see [1] and [2].
--
Fabrízio de Royes Mello
>> Blog sobre TI: http://fabriziomello.blogspot.com
Fabrízio de Royes Mello
>> Blog sobre TI: http://fabriziomello.blogspot.com
>> Perfil Linkedin: http://br.linkedin.com/in/fabriziomello
В списке pgsql-admin по дате отправления: