Re: psql and regex not like

On Thu, Mar 6, 2025 at 6:11 AM hubert depesz lubaczewski wrote: > On Thu, Mar 06, 2025 at 04:37:56AM -0500, Ron Johnson wrote: > > This statement runs great from the psql prompt. Does exactly what I > want. > > select datname from pg_database WHERE datname !~ 'template|postgres' > ORDER > > BY d

Re: psql and regex not like

On Thu, Mar 6, 2025 at 11:24 AM Ron Johnson wrote: > I already do that. This is part of a long chain of commands so I'm trying to > minimize the length of commands. but given that your regexp patterns are not anchored, they are not equivalent. I think mine is "more correct". > Anyway, it would

Re: Duplicate Key Values

I tried adding a dummy column with different values and then deleting one, as you suggested. Got the same message. Mark Brady, Ph.D. Deputy Chief Data Officer, TRMC amazon.com/author/markjbrady From: mark bradley Sent: Thur