[development] Extend database abstraction layer, to include table creation.

[Richard Morse]

On May 11, 2006, at 3:36 PM, Karoly Negyesi wrote:

> On Thu, 11 May 2006 20:31:32 +0200, Adrian Rossouw  
> <adrian at bryght.com> wrote:
>
>> 1. db_create_table($tablename, $columns); // columns is an  
>> associative array with the 'name' => 'type'
>
> Ah yes. And between 'character variable' of postgres and 'varchar'  
> of mysql, which one ?

The last time I checked (about two or three days ago?), PostgreSQL  
accepted column definitions using 'varchar' just fine...

According to
http://www.postgresql.org/docs/7.2/static/datatype.html
varchar is an alias for character varying.

Now, there might be problems with blob fields...

Ricky