2010/10/6 Fábio Gibon - Comex System <gi...@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]. [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
