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 from the 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 and the 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 those constraints and add them back after changing the table.

Regards,
David Witham
Telephony Platforms Architect
Unidial

-----Original Message-----
From: Luis Mix [mailto:ksql2002(at)yahoo(dot)com(dot)mx]
Sent: Wednesday, 2 April 2003 00:35
To: pgsql-sql(at)postgresql(dot)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 that my table can accept repeated records, but not Null.
How can I do that?
SomeBody can help me please?
My table has information at the moment,what can I do for maintain
it?

--
Best regards,
Luis mailto:ksql2002(at)yahoo(dot)com(dot)mx

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