From: | Fabrízio de Royes Mello <fabriziomello(at)gmail(dot)com> |
---|---|
To: | Fábio Gibon - Comex System <gibon(at)comexsystem(dot)com(dot)br> |
Cc: | PostgreSQL - mailing list <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: Lost file |
Date: | 2010-10-06 15:16:37 |
Message-ID: | AANLkTimhrySn6JWSuR3AU9pf-+JdktoY8yE+BhpcbQ=w@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Fábio Gibon - Comex System | 2010-10-06 15:28:16 | Re: Lost file |
Previous Message | Marc Fromm | 2010-10-06 15:03:28 | newer release branch |