Re: Mimic ALIAS in Postgresql?

2024-01-22 Thread Ron Johnson
On Mon, Jan 22, 2024 at 6:40 PM Rob Sargent wrote: > On 1/17/24 16:25, Jim Nasby wrote: > > On 1/16/24 6:41 PM, Rob Sargent wrote: > > 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

Re: Mimic ALIAS in Postgresql?

2024-01-22 Thread Rob Sargent
On 1/17/24 16:25, Jim Nasby wrote: On 1/16/24 6:41 PM, Rob Sargent wrote: 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

Re: Mimic ALIAS in Postgresql?

2024-01-22 Thread Jim Nasby
On 1/16/24 6:41 PM, Rob Sargent wrote: 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

Re: Mimic ALIAS in Postgresql?

2024-01-16 Thread Rob Sargent
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

Re: Mimic ALIAS in Postgresql?

2024-01-16 Thread Rob Sargent
On 1/16/24 17:03, Ron Johnson wrote: On Tue, Jan 16, 2024 at 5:57 PM Rob Sargent wrote: On 1/16/24 15:39, Ron Johnson wrote: On Tue, Jan 16, 2024 at 5:31 PM Rob Sargent wrote: On 1/16/24 10:20, Ron Johnson wrote: Some RDBMSs have CREATE ALIAS, which allows you

Re: Mimic ALIAS in Postgresql?

2024-01-16 Thread Jim Nasby
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

Re: Mimic ALIAS in Postgresql?

2024-01-16 Thread Ron Johnson
On Tue, Jan 16, 2024 at 5:57 PM Rob Sargent wrote: > On 1/16/24 15:39, Ron Johnson wrote: > > On Tue, Jan 16, 2024 at 5:31 PM Rob Sargent wrote: > >> On 1/16/24 10:20, Ron Johnson wrote: >> >> Some RDBMSs have CREATE ALIAS, which allows you to refer to a table by a >> different name (while also

Re: Mimic ALIAS in Postgresql?

2024-01-16 Thread Rob Sargent
On 1/16/24 15:39, Ron Johnson wrote: On Tue, Jan 16, 2024 at 5:31 PM Rob Sargent wrote: On 1/16/24 10:20, Ron Johnson wrote: Some RDBMSs have CREATE ALIAS, which allows you to refer to a table by a different name (while also referring to it by the original name). We have

Re: Mimic ALIAS in Postgresql?

2024-01-16 Thread Ron Johnson
On Tue, Jan 16, 2024 at 5:31 PM Rob Sargent wrote: > On 1/16/24 10:20, Ron Johnson wrote: > > Some RDBMSs have CREATE ALIAS, which allows you to refer to a table by a > different name (while also referring to it by the original name). > > We have an application running on DB2/UDB which (for

Re: Mimic ALIAS in Postgresql?

2024-01-16 Thread Rob Sargent
On 1/16/24 10:20, Ron Johnson wrote: Some RDBMSs have CREATE ALIAS, which allows you to refer to a table by a different name (while also referring to it by the original name). We have an application running on DB2/UDB which (for reasons wholly unknown to me, and probably also to the current

Re: Mimic ALIAS in Postgresql?

2024-01-16 Thread hector vass
On Tue, 16 Jan 2024, 17:21 Ron Johnson, wrote: > Some RDBMSs have CREATE ALIAS, which allows you to refer to a table by a > different name (while also referring to it by the original name). > > We have an application running on DB2/UDB which (for reasons wholly > unknown to me, and probably also

Re: Mimic ALIAS in Postgresql?

2024-01-16 Thread Jim Nasby
On 1/16/24 11:20 AM, Ron Johnson wrote: Some RDBMSs have CREATE ALIAS, which allows you to refer to a table by a different name (while also referring to it by the original name). We have an application running on DB2/UDB which (for reasons wholly unknown to me, and probably also to the

Re: Mimic ALIAS in Postgresql?

2024-01-16 Thread Adrian Klaver
On 1/16/24 11:40 AM, Ron Johnson wrote: On Tue, Jan 16, 2024 at 2:24 PM Adrian Klaver wrote: On 1/16/24 10:11 AM, Ron Johnson wrote: On Tue, Jan 16, 2024 at 12:40 PM Adrian Klaver wrote: On 1/16/24 09:20, Ron Johnson wrote: > Some RDBMSs have CREATE ALIAS,

Re: Mimic ALIAS in Postgresql?

2024-01-16 Thread Ron Johnson
On Tue, Jan 16, 2024 at 2:24 PM Adrian Klaver wrote: > > On 1/16/24 10:11 AM, Ron Johnson wrote: > > On Tue, Jan 16, 2024 at 12:40 PM Adrian Klaver > wrote: > >> On 1/16/24 09:20, Ron Johnson wrote: >> > Some RDBMSs have CREATE ALIAS, which allows you to refer to a table by >> a >> > different

Re: Mimic ALIAS in Postgresql?

2024-01-16 Thread Adrian Klaver
On 1/16/24 10:11 AM, Ron Johnson wrote: On Tue, Jan 16, 2024 at 12:40 PM Adrian Klaver wrote: On 1/16/24 09:20, Ron Johnson wrote: > Some RDBMSs have CREATE ALIAS, which allows you to refer to a table by a > different name (while also referring to it by the original name).

Re: Mimic ALIAS in Postgresql?

2024-01-16 Thread Ron Johnson
On Tue, Jan 16, 2024 at 12:40 PM Adrian Klaver wrote: > On 1/16/24 09:20, Ron Johnson wrote: > > Some RDBMSs have CREATE ALIAS, which allows you to refer to a table by a > > different name (while also referring to it by the original name). > > > > > > > Maybe updatable views? > > CREATE VIEW

Re: Mimic ALIAS in Postgresql?

2024-01-16 Thread Adrian Klaver
On 1/16/24 09:20, Ron Johnson wrote: Some RDBMSs have CREATE ALIAS, which allows you to refer to a table by a different name (while also referring to it by the original name). Maybe updatable views? CREATE VIEW mtqry.sometable AS SELECT * FROM mtuser.sometable; Assuming sometable is the

Re: Mimic ALIAS in Postgresql?

2024-01-16 Thread Adrian Klaver
On 1/16/24 09:20, Ron Johnson wrote: Some RDBMSs have CREATE ALIAS, which allows you to refer to a table by a different name (while also referring to it by the original name). We have an application running on DB2/UDB which (for reasons wholly unknown to me, and probably also to the current

Mimic ALIAS in Postgresql?

2024-01-16 Thread Ron Johnson
Some RDBMSs have CREATE ALIAS, which allows you to refer to a table by a different name (while also referring to it by the original name). We have an application running on DB2/UDB which (for reasons wholly unknown to me, and probably also to the current developer) extensively uses this with two