Robert,
> How then can I add in a DEFAULT nextval in place of SERIAL and get
> the
> REFERENCES in there? Or can I?
You can't (as far as I know). If that's important to you, you need to
create the table first with a regular CREATE TABLE statement, then do
INSERT INTO. CREATE TABLE AS is, I believe, primarily for temporary
tables.
It's also a good idea to stay away from CREATE TABLE AS in applications
that might have to be portable; this is one statment whose syntax varies
widely from platform to platform. For example, Transact-SQL (MS) uses
SELECT ... INTO instead of CREATE TABLE AS.
-Josh Berkus
______AGLIO DATABASE SOLUTIONS___________________________
Josh Berkus
Complete information technology [EMAIL PROTECTED]
and data management solutions (415) 565-7293
for law firms, small businesses fax 621-2533
and non-profit organizations. San Francisco
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
