Where is using a table name as a "row value" documented?

2023-12-08 Thread Gulyás Attila
Hi, I asked this on Stackoverflow[0] months ago, and finally posting it here as well, along with Laurenz Albe's helpful comments: The query `SELECT * FROM table WHERE NOT (table IS NOT NULL);` finds all the rows in `table` that have a `null` value in any column. This answer[1] helped understand t

Re: `pg_restore --if-exists` clarification

2023-09-29 Thread Gulyás Attila
Thank you so much! Appreciatively, Attila On Fri, Sep 29, 2023 at 1:15 PM Tom Lane wrote: > =?UTF-8?Q?Guly=C3=A1s_Attila?= writes: > > I would love to see Tom's version in the docs! It is only slightly longer > > than the current one, but absolutely clear of the purpose of both, and > the > >

Re: `pg_restore --if-exists` clarification

2023-09-29 Thread Gulyás Attila
I would love to see Tom's version in the docs! It is only slightly longer than the current one, but absolutely clear of the purpose of both, and the behaviour when used in tandem. Appreciatively, Attila On Thu, Sep 28, 2023 at 1:03 PM Tom Lane wrote: > "David G. Johnston" writes: > >>> .. But

Re: `pg_restore --if-exists` clarification

2023-09-28 Thread Gulyás Attila
So `--if-exists` simply suppresses any notice / warning that would occur? I'm sorry if I come off as obtuse, but I have literally no idea what `--clean` and `--if-exists` do when used together. I took the quote from the Stackoverflow answer on face value, because it sounded plausible and I can't u