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?
> 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@earthlink.net> wrote in message > news:3Qv56.2577$Ps.115717@newsread2.prod.itd.earthlink.net... > > 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 > > > > > > > > >
