Skip to content

Instantly share code, notes, and snippets.

@uris77

uris77/postgres_tips.md

Created November 25, 2015 17:17
Show Gist options
  • Save uris77/3befe30001de01e37e37 to your computer and use it in GitHub Desktop.
Save uris77/3befe30001de01e37e37 to your computer and use it in GitHub Desktop.
Download ZIP
Postgres Tips
Raw
postgres_tips.md

Force a user to have a default schema other than public:

ALTER USER <user> SET search_path=<schema>;

Grant permissions to a schema for a user:

GRANT ALL PRIVILEGES ON SCHEMA <schema> to <user>;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment