I'm trying to create a table in a PostgreSQL database and I can't figure out the syntax.
The PostgreSQL site tells me
CREATE TABLE TEST (NAM VARCHAR (40), ADD VARCHAR (40), PHO VARCHAR(40));
This doesn't work ('Internal server error').
I tried $db->CREATE TABLE ..... Same error message.
I have the documentation for the module, from CPAN, but it doesn't talk about the syntax for this (or SELECT, or alot of things).
How do you create a table?
my $db = DBI->connect("dbi:pg:dbname=me;host=sql");
$db->CREATE TABLE TEST (NAM VARCHAR (40), ADD VARCHAR (40), PHO VARCHAR(40));
$db->DROP TABLE TEST;