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 1rPtxa-00F2ff-DO for pgsql-general@arkaria.postgresql.org; Wed, 17 Jan 2024 00:39:14 +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 1rPtxY-009KCZ-Ns for pgsql-general@arkaria.postgresql.org; Wed, 17 Jan 2024 00:39:12 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rPtxY-009KCR-DB for pgsql-general@lists.postgresql.org; Wed, 17 Jan 2024 00:39:12 +0000 Received: from mail-oa1-x32.google.com ([2001:4860:4864:20::32]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1rPtxR-002Clw-M6 for pgsql-general@lists.postgresql.org; Wed, 17 Jan 2024 00:39:11 +0000 Received: by mail-oa1-x32.google.com with SMTP id 586e51a60fabf-204235d0913so6759442fac.1 for ; Tue, 16 Jan 2024 16:39:05 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1705451943; x=1706056743; darn=lists.postgresql.org; h=content-transfer-encoding:in-reply-to:from:references:cc:to :content-language:subject:user-agent:mime-version:date:message-id :from:to:cc:subject:date:message-id:reply-to; bh=dnzoopqOldW1JVIrQ/G3DyeiR6NpnY/rycDMHi+gxWw=; b=ccpZeChmoe45guf1Rxei+RtFvhNw87o1KDb+fBsEfB9lMB3cds5iZqv8V3487L4UVx z0AI03Vi8V66AZh3j3AlFV90/YfGHKbM/+ORicmLhgkc9G2txdt3MQFkJwDlwUumRa34 TdoTRL806gZy98baUzj5a91wMLlk8OCRtVaNEn7kdHpj9V5I4Zhrt9Jtmd1dHypTQKbY HpBCHQU2w77fPNjTNl/TNxFaFHn3Hi0S8RSrSEo+HJTNhN0UJUgEjXRjvZvkaR2WRkQ2 +4blMDppWULdqYaNaLOf+VAA6+joeaLgL0UY4lDI1Vfgv/Jmaq4Qa7HKh0TIMOxRlPXZ LrWA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1705451943; x=1706056743; h=content-transfer-encoding:in-reply-to:from:references:cc:to :content-language:subject:user-agent:mime-version:date:message-id :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=dnzoopqOldW1JVIrQ/G3DyeiR6NpnY/rycDMHi+gxWw=; b=sIEV69eQUcjXr3j0gK2ulM4ExWnnYXQRgj6ZqcMIZXZYLUkdjcrFd6UTQFtVyD1nS/ 4HaMI6AZ5ZFpPExzYhjU+dhQBqtVeG7tLbw0DD9cRs7ZSNnSfWXF5jPlGIzOVgQH++wY hW+kftHvMbmb9MOmf3Gjo84QkIyB242DnybCnXnFTwrwQjX24RVZXpHomkI4ZN2aLGxK EkqRQ2Hp0AvL3vnT/aQjaELtwuW4340eQL7Em9mtVCgQOLBzolxXGIlc2R8DEBpmK6Cq PgkSJzw22+a3o6LMQDw2ydIrHNpqrBG4x6C/sop3arkD/bznqW0Dgo4PIkuI/WuHxuhb +TMw== X-Gm-Message-State: AOJu0YzllYJFwSAZq7HC/qJWwzRm+zmSvg+XwpPB5U/fzULntKJa1UoO dugqZiuAh1O0wrkIElk8TA== X-Google-Smtp-Source: AGHT+IHYi5eOHxTQk92+YVIRvAy8NcKiIau+1ahqr4ik/CffR4D7sIuSsSOT5apATTpqHdp/KjjA7w== X-Received: by 2002:a05:6870:f214:b0:203:d165:e4c4 with SMTP id t20-20020a056870f21400b00203d165e4c4mr10452278oao.44.1705451943639; Tue, 16 Jan 2024 16:39:03 -0800 (PST) Received: from [192.168.2.16] (070-113-014-216.res.spectrum.com. [70.113.14.216]) by smtp.gmail.com with ESMTPSA id so11-20020a056871818b00b001fb42001fa7sm3332878oab.36.2024.01.16.16.39.02 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Tue, 16 Jan 2024 16:39:03 -0800 (PST) Message-ID: <7eed1809-2ed0-4a3d-a6f0-ed4ed55bd39c@gmail.com> Date: Tue, 16 Jan 2024 18:39:01 -0600 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Mimic ALIAS in Postgresql? Content-Language: en-US To: Rob Sargent , Ron Johnson Cc: pgsql-general@lists.postgresql.org References: <484b48cd-3a6e-4585-be9b-febed445e18b@gmail.com> From: Jim Nasby 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/16/24 4:57 PM, Rob Sargent wrote: >> Or perhaps you have to beef the sed up to use word boundaries just >> in case. >> >> >> I'm not a Java web developer... 😁 > > You need to adjust you glasses if that's what you see me as. Reality is that basically all modern (as in last 20 years) SQL access is via frameworks that all use their own language and come up with SQL based on that. How hard it'd be to bulk change the schema depends entirely on the framework. -- Jim Nasby, Data Architect, Austin TX