Hacker News new | ask | show | jobs
by ubertaco 1067 days ago
I've seen MySQL clients/docs also use "schema" to refer to "this collection of tables", basically what SQLite would call "a database".

The words get really fuzzy here when you try to get a concrete and ubiquitous definition, though.

Best I can do is to say, in these queries:

    use foo;
    select id, name from foo.people where id < 10;

..."foo" is the schema in MySQL and, apparently, Postgres parlance.