[freeside] dbdef-create for postgres??

[ivan]

On Tue, May 16, 2000 at 08:50:13PM +0000, Mark Dzmura wrote:
> Does anybody have a version of dbdef-create hacked for postgres??

Sorry, not yet.

> I have never used mysql and don't know the format of what it returns from its "show"
> statements, so I'm not sure what to get postgres to return...

I need to query the database for:

1) A list of tables
2) For each table, a list of the column names, type/length. and NULL flag.
3) For each table, the primary key and other indices for the table.

> Alternatively, if somebody could send me some output from the mysql
> 
>     "show tables"
>     "show index from ..."
>     "show columns from ..."
> 
> I could probably wing it with this info...

I don't think you want to use the output from someone else's database,
espeically a different database engine.

-- 
meow
_ivan