Uwe Maiwald wrote:
> how to get the name of the sequence that is responsible for setting
> the autoincrement value of a tables primary key column?
You can use the pg_get_serial_sequence() function. You need the name of
the column in addition to the table name though.
--
Alvaro Herrera
Uwe Maiwald wrote:
> how to get the name of the sequence that is responsible for setting the
> autoincrement value of a tables primary key column?
>
> i only have the name of the table and need to have an appropiate sql
> statement.
>
>
> i need this to write a program that loops through all tab
Another Trad writes:
> My table 'client' has the unique 'client_id'.
> My test server, when I try:
> select * from client where client_id = 12
> My server returns 3 rows
We've seen bugs of that sort in the past ... what PG version is this,
and on what platform?
regard
My table 'client' has the unique 'client_id'.
My test server, when I try:
select * from client where client_id = 12
My server returns 3 rows
When I try to update this client, his name for example,using my framework
(SQLAlchemy), obviously returns the error:
"Updated rowcount 3 does not match nu
how to get the name of the sequence that is responsible for setting the
autoincrement value of a tables primary key column?
i only have the name of the table and need to have an appropiate sql
statement.
i need this to write a program that loops through all tables of a
database and then aju
