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=E1bio, 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).=20 Use a similar query do see some information about the columns of = table: SELECT * FROM information_schema.columns WHERE table_name =3D '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.htm= l --=20 Fabr=EDzio de Royes Mello >> Blog sobre TI: http://fabriziomello.blogspot.com >> Perfil Linkedin: http://br.linkedin.com/in/fabriziomello ------=_NextPart_000_00F4_01CB6551.F3696C80 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Tks=20 Fabrizio...
I didn't = want=20 believe in this...but... :(

My=20 file exists, but with 0 bytes... the table struture only... when i do = "select *=20 ..." is returned all columns but zero tuples...

thanks again
F=E1bio = Gibon

----- Original Message -----
From:=20 Fabr=EDzio de Royes Mello =
To: F=E1bio Gibon - Comex = System

Cc: PostgreSQL - mailing = list

Sent: Wednesday, October 06, = 2010 12:16=20 PM

Subject: Re: [ADMIN] Lost = file

2010/10/6 F=E1bio Gibon - Comex System <gibon@comexsystem.com.br>=

Hi everybody,
i = lost one=20 file in my file system, it's file reference the one user table = (table=20 "x")... Are there some option to recover this table? (without any = backup and=20 database isn't archive mode).

Hi F=E1bio,

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=20 working of course).

Use a similar query do see some information about the columns of=20 table:

SELECT * FROM information_schema.columns WHERE table_name =3D = '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=EDzio de Royes Mello
>> Blog sobre TI: http://fabriziomello.blogspot.com
>> Perfil Linkedin: http://br.linkedin.com/in/fabriziomello

------=_NextPart_000_00F4_01CB6551.F3696C80--