Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 41A9A133655C for ; Wed, 26 Jan 2011 03:25:12 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 31643-03 for ; Wed, 26 Jan 2011 07:25:04 +0000 (UTC) X-Greylist: delayed 00:07:14.64602 by SQLgrey-1.7.6 Received: from forward15.mail.yandex.net (forward15.mail.yandex.net [95.108.130.119]) by mail.postgresql.org (Postfix) with ESMTP id 1DA55133616B for ; Wed, 26 Jan 2011 03:25:04 -0400 (AST) Received: from web130.yandex.ru (web130.yandex.ru [95.108.130.31]) by forward15.mail.yandex.net (Yandex) with ESMTP id 710D24459C73 for ; Wed, 26 Jan 2011 10:17:47 +0300 (MSK) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yandex.ru; s=mail; t=1296026267; bh=AVJA+UMcX2qEt0d/3VtuoZgj5yRk0EZuPuL6VrMVEuQ=; h=From:To:Subject:MIME-Version:Message-Id:Date: Content-Transfer-Encoding:Content-Type; b=is7p7qbY7/I7KvyD5ZmIc8n25ZPqOv/Z1pbougCM0BIqc1K7LutMe2Du6hYdkyozs GOLqEyDRXfJVNTfJXCwVE/kpwdiRdT6Vd7ZVzLINoN8uvDFQ1+QYtbJE6lYjDIcSTZ F00xGoJv60hkR6nk/JwUNJtzEG1bjPNAT62rk3bM= Received: from localhost (localhost.localdomain [127.0.0.1]) by web130.yandex.ru (Yandex) with ESMTP id 673C35A9809B for ; Wed, 26 Jan 2011 10:17:47 +0300 (MSK) Received: from localhost (localhost [127.0.0.1]) by mail.yandex.ru with HTTP; Wed, 26 Jan 2011 10:17:46 +0300 From: msi77 To: pgsql-sql@postgresql.org Subject: Re: Queyring for columns which are exist in table. MIME-Version: 1.0 Message-Id: <194831296026267@web130.yandex.ru> Date: Wed, 26 Jan 2011 10:17:46 +0300 X-Mailer: Yamail [ http://yandex.ru ] 5.0 Content-Transfer-Encoding: 7bit Content-Type: text/plain X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=4.635 tagged_above=-5 required=5 tests=BAYES_50=0.8, FREEMAIL_ENVFROM_END_DIGIT=1.553, FREEMAIL_FROM=0.001, FSL_RU_URL=2.271, T_TO_NO_BRKTS_FREEMAIL=0.01 X-Spam-Level: **** X-Archive-Number: 201101/90 X-Sequence-Number: 35037 Why would not use information schema to checking of existence of some column in a table: select column_name from information_schema.columns where table_name='tbl'