[ZDP] BackTalk to Document The Zope Book (2.5 Edition)/Relational Database Connectivity

nobody@nowhere.com nobody@nowhere.com
Tue, 13 Aug 2002 16:33:46 -0400

A comment to the paragraph below was recently added via http://www.zope.org/Documentation/Books/ZopeBook/current/RelationalDatabases.stx#2-14


    Let's create a table in your database to use in this chapter's
    examples.  The *Test* view of the Database Connection allows you
    to send SQL statements directly to your database. You can create
    tables by typing SQL code directly into the *Test* view; there is
    no need to use a SQL Method to create tables.  Create a table
    called *employees* with the following SQL code::

      CREATE TABLE employees
      emp_id integer,
      first varchar,
      last varchar,
      salary float

      % Anonymous User - Aug. 10, 2002 1:38 am:
       What other kind of column types does ZSQL support?

      % Anonymous User - Aug. 13, 2002 4:33 pm:
       These are postgresql specific SQL commands. ZSQL supports whatever commands the underlying SQL DB supports.