Saturday, September 12, 2020

schema vs database in MySQL and PostgreSQL


TL;DR: both schema and database mean database in MySQL.



MySQL (<— you’re here in SQL client, unless you set default schema in connection)

database1 (<— you're here if use database1;)

tables


PostgreSQL

database1

public (<— you’re here in SQL client, unless you set default search_path in connection)

tables

schema1 (<— you're here if set search_path=schema1;)

tables


No comments:

Post a Comment