Skip to content

[Feat]: Postgresql improve schema search_path#653

Description

@mccuskk

Prerequisites

  • I have written a descriptive issue title
  • I have searched existing issues to ensure the feature has not already been requested

馃殌 Feature Proposal

tabularis should query the search path on a new connection and then use that, with the selected schema appended on the end. Maybe Ideally there would be a way to define or override that behaviour with a connection specific search_path rather than the one defined in postgresql.conf

Motivation

I use tabularis for postgresql and a real pain point is the schema search_path being set by tabularis. This means that to run queries where any object definition is not in the current schema I need to write something like "set search_path to public, analyst; select * from whatever;" and then run as a selection and open the second tab.

Example

No response

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions