I might have missed something in this discussion -- but isn't what you have
in your CFQUERY tags exactly the same SQL code you would use on the PostgreSQL
command line tool (psql) to create a table?
If it is identical, where did the confusion creep in? Creating tables isn't
something we all do every day via a command line SQL tool; so it's easy to
forget the exact syntax but it's by no means an undocumented procedure.
Justin Buist
On Thu, Mar 22, 2001 at 09:23:10AM +0000, Frank Hilliard wrote:
> With a lot of encouragement, I've now got CREATE TABLE working in PostgreSQL using
>Cold Fusion. I'm frankly amazed there isn't more information on this considering how
>important it is
> to be able to work remotely on Linux machines. The syntax is like this:
>
> <cfquery datasource="databasename">
> CREATE TABLE test (
> testID integer PRIMARY KEY, firstname varchar, lastname varchar,
> newdate date
> )
> </cfquery>
>
> Frank Hilliard
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-linux%40houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_linux or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
