From: | Khushboo Vashi <khushboo(dot)vashi(at)enterprisedb(dot)com> |
---|---|
To: | Thomas Kaliakos <tkaliakos(at)gmail(dot)com> |
Cc: | "pgadmin-support lists(dot)postgresql(dot)org" <pgadmin-support(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Programmatic access to the SQL tab of pgadmin |
Date: | 2022-02-22 05:01:49 |
Message-ID: | CAFOhELf96e1cyWRDGxrSwgEfsdu6JdsgD7mP8+KFjGCxpD6dsA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support pgsql-admin |
Hi,
On Mon, Feb 21, 2022 at 8:15 PM Thomas Kaliakos <tkaliakos(at)gmail(dot)com> wrote:
>
> Hi all,
>
> TL;DR; Can I run pgadmin locally without the CSRF token check?
>
No possible way to bypass CSRF token currently.
> Longer version:
> I would like to retrieve the output of the SQL tab in pgadmin for various
> resources (tables, views, functions, etc.) programmatically.
> I discovered that this might be possible if we send an http request to a
> running pgadmin address and using a url of the format:
> http://localhost:8011/browser/function/sql/1/1/215863/215876/607033
> (where the numbers represent the server group id, the server id, the
> database id, the schema id and the oid of the function)
> When I curl to this URL though I get the error that The CSRF token is
> missing.
> I tried running pgadmin in debug mode, setting the csrf headers to an
> empty list ( PGADMIN_CONFIG_WTF_CSRF_HEADERS=[]), but none of those worked.
> Is there any easy way I could retrieve the contents of the SQL tab?
> Any help would be greatly appreciated 🙏🙏
>
> You can create a feature request @
https://redmine.postgresql.org/projects/pgadmin4/issues.
Thanks,
Khushboo
>
> --
> Thanks,
> Thomas
> @tkaliakos <https://twitter.com/tkaliakos>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Ayad Mohamed | 2022-02-22 08:35:54 | "Bug #7187 - ERD in pgadmin 6.5 down png diagram 0 byte" |
Previous Message | frank77-postgres | 2022-02-21 17:57:36 | Cannot authenticate: "SCRAM authentication requires libpq 10 or later" |
From | Date | Subject | |
---|---|---|---|
Next Message | Marcia Rocha | 2022-02-22 12:13:37 | postgresql14-contrib does not install with libpython 3.7 |
Previous Message | Tom Lane | 2022-02-21 18:22:26 | Re: Can't drop subscription |