Обсуждение: Re: Auto increment

In article <vnxr5.4053$nq.48129@twister.sunsite.auc.dk>, "Mads Jensen"
<astrup_jensen@hotmail.com> wrote:
> Hi
> 
> I'm a newbiw with pgsql:
> 
> 1: Haven't been able to find the officiel manual to pgsql. What's the
> complete URL?

Hmm, I don't know, I use the book which you can find with all the rest of the docs at:
http://www.postgresql.org/docs/index.html


> 2: How can I make an auto increment with PostGreSQL? is it "inherit"?

One of two ways.  Either make the data type "serial" or you can create a sequence and 
set the default value of the field to curval(sequence).

Hi

I'm a newbiw with pgsql:

1: Haven't been able to find the officiel manual to pgsql. What's the
complete URL?
2: How can I make an auto increment with PostGreSQL? is it "inherit"?
3: The "SHOW TABLE FROM pcfocus" statement, does it work in pgsql?
If yes, what kind of variable will be "produced" and how should I parse
it PHP?
Is this right:
$sql = "SHOW TABLES FROM mydb";
$test = pg_exec($connect, $sql);
while(list($table) = each($test)){
echo $test."<BR>\n";
?
Thanks alot!

--
Med venlig hilsen/ Wishes
Mads Jensen
Homepage: http://www.pcfocus.f2s.com
E-Mail: astrup_jensen@hotmail.com
--

> 1: Haven't been able to find the officiel manual to pgsql. What's the
> complete URL?
> 2: How can I make an auto increment with PostGreSQL? is it "inherit"?
> 3: The "SHOW TABLE FROM pcfocus" statement, does it work in pgsql?

never mind, i found out myself:
1: not officiel, but anyway:
http://hea-www.harvard.edu/MST/simul/software/docs/pkg/pgsql/7.0.1/man/m
an.html
2: UNIQUE
3: Yes!

--
Med venlig hilsen/ Wishes
Mads Jensen
Homepage: http://www.pcfocus.f2s.com
E-Mail: astrup_jensen@hotmail.com
--