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 1rPtzw-00F2yq-Fs for pgsql-general@arkaria.postgresql.org; Wed, 17 Jan 2024 00:41:41 +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 1rPtzv-009Q3v-Hx for pgsql-general@arkaria.postgresql.org; Wed, 17 Jan 2024 00:41:39 +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 1rPtzv-009Q3m-7J for pgsql-general@lists.postgresql.org; Wed, 17 Jan 2024 00:41:39 +0000 Received: from mail-pl1-x62e.google.com ([2607:f8b0:4864:20::62e]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1rPtzs-002CmW-NJ for pgsql-general@lists.postgresql.org; Wed, 17 Jan 2024 00:41:38 +0000 Received: by mail-pl1-x62e.google.com with SMTP id d9443c01a7336-1d45f182fa2so84566305ad.3 for ; Tue, 16 Jan 2024 16:41:36 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1705452095; x=1706056895; darn=lists.postgresql.org; h=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=gPYRTFijwcmDHcxyZp7l9zfU5le0NUknE+JJSV+IBU8=; b=YHLe1Ev8zrxQgMFgHCF3y8uGYlF0HQTv8yTCTcFO5rL1nK+alTzggP2uLZtqsRtBS0 tz91FHiBbCkf0/l4PtMver2cSjvKBKmk2NUefkROI/WIYk2MzpuexaZlJxsBoAXoNyL7 CibDWBrfkx3xSyMHabI8GK842zlecL4A82ilzQJpbpe0f3i0W28nvpEietwF8+VE5FdT 2P9OgIR5TZO61coanpQlJwu7nmDMpZ7tvPB5G5M4jNrzO/YT5ySx8hGayA6snNDAK+ey Dwbb7jFsfeVknOkxw85teI6jNO6XAV16zzjv24ChyqR6fYQGgnsLUhZEzGBOtSpRTTAF fS1w== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1705452095; x=1706056895; h=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=gPYRTFijwcmDHcxyZp7l9zfU5le0NUknE+JJSV+IBU8=; b=Ll/SjoeKwgLz88KG2mNWx58W8S5Fty1Xmg9XG6tqiYMtTFrXWmHDczbYSwMW4a+8pQ xl+zyE37UqWY5JSzK8WV0A4STh90DcTHUoYRtWA4zCR0vwnKhpDbU8h4NWAk6UFl3mTS zqpuiV3Wc/bLfP/lC//JsnkhYWy5X93Um37F3KJ/3bwYEEpqBtYmQa89trJ+4MVPt/PU KEsSoourYgW8D+m3JaPqXITaIDzLYWz8YUeuq1LPb8ah/AIlgKdxZA4ZRSDGkprqvR7L QYOyJzL8fpXiu/eAeHjo23UJglHFY3BTRfhRBE4/YclKkpgPhTWgdf2o7MMgfoEtMjkT mlSw== X-Gm-Message-State: AOJu0YxKDcmF7uvy4xg5n0CRJ00FvHXEl0UeB4+4sKdPJ/I716N4Fh2t OKbkIjK0qOgq4nJFrOagXPc= X-Google-Smtp-Source: AGHT+IFQINhMvQfOyIV0bQ5sehw0N6xtb0yEXvIlOnliM6zdIBoQMbMkdM0aRjfGUGhNY2/YpCX20Q== X-Received: by 2002:a17:902:9a4c:b0:1d4:cfcd:39a0 with SMTP id x12-20020a1709029a4c00b001d4cfcd39a0mr7567730plv.8.1705452094681; Tue, 16 Jan 2024 16:41:34 -0800 (PST) Received: from [192.168.1.3] (c-76-140-27-218.hsd1.ut.comcast.net. [76.140.27.218]) by smtp.gmail.com with ESMTPSA id az2-20020a170902a58200b001cc1dff5b86sm9865734plb.244.2024.01.16.16.41.34 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Tue, 16 Jan 2024 16:41:34 -0800 (PST) Content-Type: multipart/alternative; boundary="------------UQFUFvZynfTw2V4GA8fDZCJe" Message-ID: <000c6cb5-94df-4c38-9b00-9e48c400c3e6@gmail.com> Date: Tue, 16 Jan 2024 17:41:33 -0700 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Mimic ALIAS in Postgresql? Content-Language: en-CA To: Jim Nasby , Ron Johnson Cc: pgsql-general@lists.postgresql.org References: <484b48cd-3a6e-4585-be9b-febed445e18b@gmail.com> <7eed1809-2ed0-4a3d-a6f0-ed4ed55bd39c@gmail.com> From: Rob Sargent In-Reply-To: <7eed1809-2ed0-4a3d-a6f0-ed4ed55bd39c@gmail.com> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------UQFUFvZynfTw2V4GA8fDZCJe Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit On 1/16/24 17:39, Jim Nasby wrote: > 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. Hm, it's a string /somewhere/.  The rest of this thread might be accused of adding to the problem. --------------UQFUFvZynfTw2V4GA8fDZCJe Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit
On 1/16/24 17:39, Jim Nasby wrote:
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.
Hm, it's a string /somewhere/.  The rest of this thread might be accused of adding to the problem.

--------------UQFUFvZynfTw2V4GA8fDZCJe--