.\"                                      Hey, EMACS: -*- nroff -*-
.\" First parameter, NAME, should be all caps
.\" Second parameter, SECTION, should be 1-8, maybe w/ subsection
.\" other parameters are allowed: see man(7), man(1)
.TH pgml2sql 1 "August 29, 2002"
.\" Please adjust this date whenever revising the manpage.
.\"
.\" Some roff macros, for reference:
.\" .nh        disable hyphenation
.\" .hy        enable hyphenation
.\" .ad l      left justify
.\" .ad b      justify to both left and right margins
.\" .nf        disable filling
.\" .fi        enable filling
.\" .br        insert line break
.\" .sp <n>    insert n+1 empty lines
.\" for manpage-specific macros, see man(7)
.SH NAME
pgml2sql \- convert a pgml file to SQL schema
.SH SYNOPSIS
.B pgml2sql
.RI -f " pgml_file"
[OPTIONS]
.br
.SH DESCRIPTION
Once you have designed your database schema in pgml syntax, you
want to convert your pgml file to sql commands wich create that
very base. pgml2sql do just that.
.\" TeX users may be more comfortable with the \fB<whatever>\fP and
.\" \fI<whatever>\fP escape sequences to invode bold face and italics, 
.\" respectively.
.SH OPTIONS
A summary of options is included below.
.TP
.B \-h
Show summary of options.
.TP
.B \-f "file"
Name of pgml file (mandatory).
.TP
.B \-o "file"
Name for an output file (stdout by default).
.TP
.B \-i "id_sequence"
By default, every tables id (the unique key) are named
.IR id_tablename ,
and are of type
.IR "SERIAL PRIMARY KEY" .
You can change this by providing a new
.I id_sequence
like, for example,
.I "uid SERIAL PRIMARY KEY"
so that every keys have the same name.
.TP
.B \-r "default_value_for_reference"
You can set a default value for all your references like, said,
.IR "0" .
.TP
.B \-u
Use postgreSql isa keyword for inheritance.
.TP
.B \-c
Add constraints upon references based on relationships (either
"NOT NULL", "ON DELETE CASCADE", or "ON DELETE SET NULL".
.TP
.B  \-x
Create indexes on every id.
.SH SEE ALSO
.BR pgml (5),
.BR pgml2dot (1).
.br
.SH AUTHOR
This manual page was written by PimenTech staff <info@pimentech.net>.