Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rPPuK-00BQKV-Ev for pgsql-general@arkaria.postgresql.org; Mon, 15 Jan 2024 16:33:52 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rPPuJ-00GOOz-AF for pgsql-general@arkaria.postgresql.org; Mon, 15 Jan 2024 16:33:51 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rPPuI-00GOOr-V3 for pgsql-general@lists.postgresql.org; Mon, 15 Jan 2024 16:33:50 +0000 Received: from wout4-smtp.messagingengine.com ([64.147.123.20]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rPPuF-001fuI-W4 for pgsql-general@lists.postgresql.org; Mon, 15 Jan 2024 16:33:49 +0000 Received: from compute7.internal (compute7.nyi.internal [10.202.2.48]) by mailout.west.internal (Postfix) with ESMTP id 62D063200A70; Mon, 15 Jan 2024 11:33:46 -0500 (EST) Received: from mailfrontend1 ([10.202.2.162]) by compute7.internal (MEProxy); Mon, 15 Jan 2024 11:33:46 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aklaver.com; h= cc:content-transfer-encoding:content-type:content-type:date:date :from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:subject:subject:to:to; s=fm2; t=1705336425; x=1705422825; bh=P661LVbKn67Vl7YS9axRmxpmLwYQt+S37PjYb0f91TQ=; b= uXNBaKvoCNVZ7aEYTlH6Obg5pvv0zKl/bg3JtlhS/rPoAHRBhaCoAMxDxqUyxBf4 6z3LxIwRAklyx6D4n4fTQjdSeQGYeRyc/XFoLePJ3wPDjES8ZgZFyHWrtJTLYdIl QuFeBkyBK6DpbVSm4+MtbmNmU9/emjxXc0Q5JAmV98cVAzqWr/bvRCnBYiy9Bl/2 TEm+z8Cxw8zbJ2h69GKJglrU5AZ/Eaxt7ePEFtB5l2IESyokfsjhKBOTz83YyA40 5zjZj+O+hAPo7fForOp3//aya+iyNj1ZUT858O4c4UNA3AfPHbYzYFwoYkjA/j/6 icF4GnBHLD5pkyn0lgDnnA== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-transfer-encoding:content-type :content-type:date:date:feedback-id:feedback-id:from:from :in-reply-to:in-reply-to:message-id:mime-version:references :reply-to:subject:subject:to:to:x-me-proxy:x-me-proxy :x-me-sender:x-me-sender:x-sasl-enc; s=fm3; t=1705336425; x= 1705422825; bh=P661LVbKn67Vl7YS9axRmxpmLwYQt+S37PjYb0f91TQ=; b=a lTFdLYoYwhfFZCCdVZ/itODGKqlaQzEm6/JdUhk1lT/7hasuc1t1XB6WslIoybdo TfLJ4jDHckK3/Ntm6wO3HCssii1a+K3CREbPrPZsihMcCuKsop2e+tjHDi1w+a2I soNodR+y9KhzOQC3RIq6K+a9+/rWH75DX5p44YAEZ+2oG4qFVvhU+w/6a2kBXJRt 39IMvs3a6IYh8aVluLlcbfPin+aF4Hyy3xBcKB+p9Y1FqXRpGH4ExZXoDkMmdGkQ QkH8UA83vKNLJCB8KkFYYFnYqHJET2YLlbG6eJGmFhDBSlLKjJ/R1WxN4Hpy9/N/ a1y2ZmFEu5OkIEr/6BeVg== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvkedrvdejuddgleduucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucenucfjughrpefkffggfgfuvfhfhfgjtgfgsehtke ertddtvdejnecuhfhrohhmpeetughrihgrnhcumfhlrghvvghruceorggurhhirghnrdhk lhgrvhgvrhesrghklhgrvhgvrhdrtghomheqnecuggftrfgrthhtvghrnhepleegveekke ekueeigfdtveeileeuhfefudefteekjeffkeejueejheegheegkedtnecuffhomhgrihhn pehpohhsthhgrhgvshhqlhdrohhrghenucevlhhushhtvghrufhiiigvpedtnecurfgrrh grmhepmhgrihhlfhhrohhmpegrughrihgrnhdrkhhlrghvvghrsegrkhhlrghvvghrrdgt ohhm X-ME-Proxy: Feedback-ID: i76984098:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Mon, 15 Jan 2024 11:33:45 -0500 (EST) Message-ID: Date: Mon, 15 Jan 2024 08:33:44 -0800 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Unable to find column Content-Language: en-US To: arun chirappurath , pgsql-general@lists.postgresql.org References: From: Adrian Klaver In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 1/15/24 08:16, arun chirappurath wrote: > Dear all, > > I have a table automobile which has a column id. > > Table consists of id,make,year of manufacturing > > I use dbeaver for querying.. > > Select * from automobile provides me results > > However select id from automobile yields column doesn't exists. > > I tried double quotes on id As well but same error. > > But if I drag and drop id or use the id which is auto prompted from > dbeaver,it works 💪. > > select "id" from automobile using drag and drop of id in dbeaver works. > > But if I manually type "id" it won't. > > Any clue on this. Do you have psql(https://www.postgresql.org/docs/current/app-psql.html( available? If so in psql what does: \d automobile return? > > Visually both statements are alike > > > Table is in public schema. > > Thanks, > Arun > > > > -- Adrian Klaver adrian.klaver@aklaver.com