Re: DROP SEQUENCE ?

Figure it out:

metamousetrap=> create table my_table (first serial, second varchar);
NOTICE: CREATE TABLE will create implicit sequence 'my_table_first_seq' for SERIAL column 'my_table.first'
NOTICE: CREATE TABLE/UNIQUE will create implicit index 'my_table_first_key' for table 'my_table'
CREATE
metamousetrap=> drop table my_table;
DROP
metamousetrap=> drop sequence my_table_first_seq;
DROP

Anyone know how to list what sequences already exist?

Thanks, Ian

"Ian deSouza" <iandesouza(at)earthlink(dot)net> wrote in message news:%4I56(dot)7010$Ps(dot)320023(at)newsread2(dot)prod(dot)itd(dot)earthlink(dot)net(dot)(dot)(dot)
> The PostgreSQL doc referencing this situation is at
> http://www.postgresql.org/devel-corner/docs/user/datatype.htm#AEN1181
> but it doesn't explain what the syntax is nor does it give an example.
> So if Employee has an attribute called ID that is of type SERIAL, and we do
> a
> "DROP TABLE EMPLOYEE"
> what kind of call should we issue to drop the sequence?
> DROP SEQUENCE ...??
>
> "Ian deSouza" <iandesouza(at)earthlink(dot)net> wrote in message
> news:3Qv56(dot)2577$Ps(dot)115717(at)newsread2(dot)prod(dot)itd(dot)earthlink(dot)net(dot)(dot)(dot)
> > Anybody know the syntax of the DROP SEQUENCE sql statement for PostgreSQL?
> >
> > Once I create a table with an attribute of type SERIAL, and drop the
> table,
> > I cannot recreate the table since the sequence already exists (and DROP
> > TABLE tableName does not remove the sequence entry). Does anybody know
> what
> > I would have to do to follow the DROP TABLE w/ to remove the "sequence"
> > created by the SERIAL datatype?
> >
> > Thanks in advance, Ian
> >
> >
> >
>
>
>