SQL Workbench/J set schema in tab

Question

How do I set the schema in an editor tab in SQL Workbench/J?

(something similar to "USE" in SQL Server/Management Studio)

in my interface (under the menu bar, to the right of the buttons), it shows I am in the "public" schema, but I can't figure out how to select a different one; I have a bunch of queries, and I'd like to not have to fully qualify every table

if it matters, I'm using RedShift as the database (don't know the version)
java version: 1.8.0_91-b15 (64bit)
SQL Workbench/J build: 118

SQL WorkbenchJ SQL WorkbenchJ · Accepted Answer · 2018-09-04T18:06:06

I don't know or use Redshift, but as it's based on an (ancient version of) Postgres, setting the current schema should work:

set schema='other_schema';

Or change the search_path:

set search_path=public, other_schema;

Note that for set schema the schema name needs to be put in single quotes, but not if you set the search_path (at least that's how Postgres works)

Build 118 is really old, you should update to a more recent version

SQL Workbench/J set schema in tab

1 Answers