Re: How can I quit this: "Unique " to my table?

Hi Luis,

I presume you want to remove the unique column constraint?

The ALTER TABLE command doesn't allow you to do this so another way is as follows:

pg_dump -t b_prestamo MyDatabase > b_prestamo.sql
Edit the b_prestamo.sql file:Add DROP TABLE b_prestamo; before the create table statement.Remove the unique keyword
fromthe no_inventa column 
psql MyDatabase < b_prestamo.sql

This will drop and recreate the table and reload the data currently in the table (the pg_dump file contains the schema
andthe data for the table). 

If you have any reference or foreign key constraints that refer to the b_prestamo table, then you will need to drop
thoseconstraints and add them back after changing the table. 

Regards,
David Witham
Telephony Platforms Architect
Unidial

-----Original Message-----
From: Luis Mix [mailto:ksql2002@yahoo.com.mx]
Sent: Wednesday, 2 April 2003 00:35
To: pgsql-sql@postgresql.org
Subject: [SQL] How can I quit this: "Unique " to my table?


Hello pgsql-sql,
 When my table was create I wrote this:
 MyDatabase=# create table b_prestamo(no_inventa char(16) unique not null, cve_area char(10), date1 date); I need now
thatmy table can accept repeated records, but not Null. How can I do that? SomeBody can help me please? My table has
informationat the moment,what can I do for maintain it?   

--
Best regards,Luis                          mailto:ksql2002@yahoo.com.mx


---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly