Is there a way to automatically scan a table and report the format of data
for each column?
Regards,
David
> b...@yugabyte.com wrote:
>
>> ddevie...@gmail.com wrote:
>>
>>> b...@yugabyte.com wrote:
>>>
>>> …Then I did this:
>>>
>>> with c as (
>>> select
>>>proname::text as name,
>>>pronamespace::regnamespace::text as schema,
>>>aclexplode(proacl)as
On 2022-Feb-13, Guyren Howe wrote:
> I’m back to just having no earthly idea why anyone who finds relations
> to be a productive tool for building a model would think that SQL
> being the only means to do that is Okay.
There are aspects other than technical reasons alone why some things
live on w
On Tue, Feb 15, 2022 at 02:18:35PM -0600, Merlin Moncure wrote:
> Exactly. SQL is proven to be more productive and code written in it
> has longer longevity than alternatives. It's also generally more
> terse in the hands of a good author. The authors of all the 'SQL
> sucks' rants don't really e
On Sun, Feb 13, 2022 at 4:00 AM Pavel Stehule wrote:
>
>
>
> ne 13. 2. 2022 v 10:45 odesílatel Guyren Howe napsal:
>>
>>
>> The MySQL autocomplete is designed without context filtering. Maybe we can
>> have this implementation too (as alternative)
>>
>> so using all column names + all table name
On 16/02/22 1:58 am, Marc Millas wrote:
another way would be to, while everything running, you create a second
slave on the new machine on rocky8 with a pg_basebackup
Thanks, I did consider this as well. Last night I did the move using
the rsync approach and it worked very well.
--
=-=-=-
On 2/15/22 01:06, A Shaposhnikov wrote:
Interestingly I have a second PG 14.2 database, with identical table
definitions, but about 10% smaller row counts, and the exact same query
works fast there without the 2nd condition:
Are you sure about the 10%? Because in the plans from the firs
Hi,
another way would be to, while everything running, you create a second
slave on the new machine on rocky8 with a pg_basebackup.
and start the new slave.
when low activity, you just stop the master, then promote the slave => new
master up
then modify the connection line in your recovery.conf
On Tue, 2022-02-15 at 11:08 +, Shaozhong SHI wrote:
> Can anyone remind me of the meaning and use of operator %.
https://www.postgresql.org/docs/current/pgtrgm.html#PGTRGM-OP-TABLE
Yours,
Laurenz Albe
Dear David,
> Can anyone remind me of the meaning and use of operator %.
I can gladly report that I remember having seen relevant documentation on
that operator while Reading up in The Fine Manual on json_to_row following
the hint Ion kindly provided.
It was amazing ! Reading up on that helped
Can anyone remind me of the meaning and use of operator %.
It works in one of scripts like WHERE NOT (street_name % designatedname)
Regards,
David
11 matches
Mail list logo
