Skip site navigation (1) Skip section navigation (2)

Re: Auto-increment serial (Postgresql JDBC driver w/

From: "Jaroslaw J(dot) Pyszny" <arghil(at)poczta(dot)onet(dot)pl>
To: pg(at)fastcrypt(dot)com
Cc: pgsql-jdbc <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: Auto-increment serial (Postgresql JDBC driver w/
Date: 2004-09-22 19:11:12
Message-ID: 1095880271.22986.37.camel@lx.siec (view raw or flat)
Thread:
Lists: pgsql-jdbc
W liście z sro, 22-09-2004, godz. 00:50, Dave Cramer pisze: 
> Sorry, missed one more where clause.
> 
> select column_default from information_schema.columns where table_name =
> 'xyz' and column_name = 'id';
> 
> This assumes a table defined like create table xyz (id serial);
It's works but only for the owner of the table
or I do something wrong ;)

Jarek
-- 
8  \\|||//  Jarosław J. Pyszny <arghil(at)poczta(dot)onet(dot)pl>
b   (o|o)    Linux admin/devel ("Vitae,non scholae,discimus")
i  --\_/--   Linux user: #96704    (http://counter.li.org)
t =->komputer(y) - daj znać jeśli chcesz się pozbyć <-=


In response to

Responses

pgsql-jdbc by date

Next:From: Tom LaneDate: 2004-09-22 19:50:43
Subject: Re: Char(100) fields
Previous:From: WaldomiroDate: 2004-09-22 18:27:15
Subject: Char(100) fields

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group