[SQL] Database recovery in postgres 7.2.4.

one tell me how to recover those missing records? Thanks, Santosh ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org

[SQL] Queyring for columns which are exist in table.

x27;))::name FROM tbl; checkcolumn - c2 c2 c2 c2 c2 c2 c2 c2 (8 rows) mydb=# Above query should return actual values present for c2 column in tbl. But it's not working as desired. Please help me in this. Thanks in advance, Santosh.

[SQL] Queyring for columns which are exist in table.

OM tbl; mydb=# SELECT (checkColumn('tbl','c2','0'))::name FROM tbl; checkcolumn - c2 c2 c2 c2 c2 c2 c2 c2 (8 rows) mydb=# Above query should return actual values present for c2 column in tbl. But it's not working as desired. Please help me in this. Thanks in advance, Santosh.

Re: [SQL] [GENERAL] Queyring for columns which are exist in table.

at it take care of newly added columns. Thanks, Santosh. -Original Message- From: Thom Brown [mailto:t...@linux.com] Sent: Thursday, January 27, 2011 3:09 PM To: Santosh Bhujbal (sabhujba) Cc: pgsql-sql@postgresql.org; pgsql-gene...@postgresql.org Subject: Re: [GENERAL] Queyring for co