Re: Lost file

2010/10/6 Fábio Gibon - Comex System <gibon(at)comexsystem(dot)com(dot)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].

[1] http://www.postgresql.org/docs/current/interactive/catalogs.html
[2]
http://www.postgresql.org/docs/current/interactive/information-schema.html

--
Fabrízio de Royes Mello
>> Blog sobre TI: http://fabriziomello.blogspot.com
>> Perfil Linkedin: http://br.linkedin.com/in/fabriziomello