Skip to content

Instantly share code, notes, and snippets.

@StuffbyYuki

StuffbyYuki/switch_schema.sql

Created February 22, 2022 03:32
Show Gist options
  • Save StuffbyYuki/2392aec685e71ad8445307164ad8a410 to your computer and use it in GitHub Desktop.
Save StuffbyYuki/2392aec685e71ad8445307164ad8a410 to your computer and use it in GitHub Desktop.
Download ZIP
Postgres db choose your schema for sql query use
Raw
switch_schema.sql
SHOW search_path;
SET search_path TO your_schema;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment