Re: What does 'schema' mean ? - Mailing list pgsql-novice

From Neil Saunders
Subject Re: What does 'schema' mean ?
Date
Msg-id ddcd549e0601090752x79e0b04dufb62006fcbb845b1@mail.gmail.com
Whole thread Raw
In response to What does 'schema' mean ?  (Joao Miguel Ferreira <jmf@estg.ipvc.pt>)
Responses Re: What does 'schema' mean ?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
http://www.webopedia.com/TERM/S/schema.html:

Pronounce skee-ma, the structure of a database system, described in a
formal language supported by the database management system (DBMS). In
a relational database, the schema defines the tables, the fields in
each table, and the relationships between fields and tables.

Schemas are generally stored in a data dictionary. Although a schema
is defined in text database language, the term is often used to refer
to a graphical depiction of the database structure.

So basically, the design of your database.

HTH,

Neil.

On 1/9/06, Joao Miguel Ferreira <jmf@estg.ipvc.pt> wrote:
> Hello again,
>
> thx very much for all the previous feedback....
>
> here's another one: what do database people mean by 'schema' ?
>
> jmf
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
>       subscribe-nomail command to majordomo@postgresql.org so that your
>       message can get through to the mailing list cleanly
>

pgsql-novice by date:

Previous
From: Joao Miguel Ferreira
Date:
Subject: What does 'schema' mean ?
Next
From: "A. Kretschmer"
Date:
Subject: Re: how to recall the initial definition (CREATE TABLE)