d like to suggest joining forces for an
ideal outcome.
[1] https://www.youtube.com/watch?v=6ahTb-7C05c
[2] https://commitfest.postgresql.org/patch/5473/
Best Regards,
Sadeq Dousti & Sergey Dudoladov
ine with \d (t, i, m, s, etc.) are used to show an
object type. In that sense, they are also flags, but the generic nature of
S and x flags made them stand out in the documentation.
Best regards,
Sadeq
On Fri, Mar 28, 2025, 11:27 Christoph Berg wrote:
> Re: Sadeq Dousti
> > > I t
Sorry Greg,
Just understood what you mean. Please find attached the v6 of the patch.
Best regards,
Sadeq
v6-0001-psql-acommand-for-non-partitioned-tables-indexes.patch
Description: Binary data
> I think this is the wrong way round.
> It should be \dtN instead of \dNt.
Hi Christoph,
The order does not matter, the user can use \dNt or \dtN, as they do
exactly the same thing. Letters coming after \d can be freely permuted. If
you mean a change to the documentation or tests, I can apply wha
> I think it's fine the way it is, with regards to v10 check. Can you post a
> rebased patch?
>
Hi Greg,
I just checked here: https://commitfest.postgresql.org/patch/5594/
Seems the patch is OK with the latest master, and no rebase is needed.
Do you mean that instead of a diff, I post a patch?
B
:
select * from pg_stat_activity join pg_stat_session using (pid);
I suggest adding all or some of the immutable columns of pg_stat_activity
to pg_stat_session, thus excluding the need to join the two views (for all
practical purposes).
Best Regards,
Sadeq Dousti
e columns of pg_stat_activity
to pg_stat_session, thus excluding the need to join the two views (for all
practical purposes).
Best Regards,
Sadeq Dousti
ter should update the above comment to the least supported
version for client code.
Best Regards,
Sadeq Dousti
Thanks a lot Greg!
> Changes look good to me, thanks. Can you make a new patch that applies a
single set of changes to HEAD?
Please find attached the diff to Head in a single file.
Best Regards,
Sadeq Dousti
diff --git a/doc/src/sgml/ref/psql-ref.sgml b/doc/src/sgml/ref/psql-ref.sgml
in
Dear Greg,
Thank you so much for the kind and prompt review!
Please find the patches attached. The second patch (0002) is where I
applied the requested changes.
Best regards,
Sadeq Dousti
On Wed, Feb 26, 2025 at 1:01 AM Greg Sabino Mullane
wrote:
> The patch applies cleanly, and works
Thanks Greg and others for the feedback!
Please find attached the patch for implementing \dN (including \dNt, \dNi,
\dNit).
Best Regards,
Sadeq Dousti
From d8fde4b05eee95089548384c07b59304f2fecc1c Mon Sep 17 00:00:00 2001
From: Sadeq Dousti <3616518+msdou...@users.noreply.github.com>
Dat
tition. What I'd like is to show roots as well as
non-partitioned tables.
If there are no hard objections, I'll proceed with adding the N letter
to \d commands.
Best Regards,
Sadeq Dousti
this defense
> of your idea.)
Oops! Thanks for mentioning this. I sent the previous email to the list
as well.
Best Regards,
Sadeq Dousti
it at first, but that command is for displaying
partitions, while I want the opposite: Don't display partitions at all.
I tried to detail why I didn't use \dP or any existing \d commands
in the first email of the thread (section "Design Decision").
Best Regards,
Sadeq Dousti
> Sorry an id was missing in psql documentation, thus CI was failing.
Combining patches into one, as otherwise CI does not combine them.
Best Regards
Sadeq Dousti
From ad81b71fe67174aebd7f6c02a82aa0ab88ff Mon Sep 17 00:00:00 2001
From: Sadeq Dousti <3616518+msdousti@users.noreply.gith
Sorry an id was missing in psql documentation, thus CI was failing.
Please find attached a patch that fixes this issue.
Best Regards,
Sadeq Dousti
Tech Lead and Staff Software Engineer at Trade Republic Bank GmbH
From c7b7f39c171648f3193cb9d61a4815ac32b779e3 Mon Sep 17 00:00:00 2001
From: Sadeq
below.
Best Regards,
Sadeq Dousti
Tech Lead and Staff Software Engineer at Trade Republic Bank GmbH
Summary
The \dh command provides a concise overview of high-level (root)
relations, including tables and indexes. This helps DBAs and developers
quickly identify the core
17 matches
Mail list logo
