[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.