[pgadmin-support] Re:  How to use the SET data type?  Help plz!

2003-10-27 Thread pgadmin
I see your points. So how is the best way to implement this type of "set" idea in something like postgres? Say I have a column named primary colors, and I want to limit this to red, blue, and yellow. How is the best way to do this without a mysql set? Thanks > > Odd that it is a selectable

Re: [pgadmin-support] How to use the SET data type? Help plz!

2003-10-27 Thread Christopher Kings-Lynne
I see your points. So how is the best way to implement this type of "set" idea in something like postgres? Say I have a column named primary colors, and I want to limit this to red, blue, and yellow. How is the best way to do this without a mysql set? CREATE TABLE foo ( color varchar(

Re: [pgadmin-support] RE: [pgadmin-support] Re: How to use the SET

2003-10-27 Thread Andreas Pflug
Dave Page wrote: -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 27 October 2003 04:17 To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: [pgadmin-support] Re: How to use the SET data type? Help plz! Odd that it is a selectable datatype in pgadmin then

Re: [pgadmin-support] dump and restore in pgadmin

2003-10-27 Thread Jean-Michel POURE
Le Lundi 27 Octobre 2003 05:11, [EMAIL PROTECTED] a écrit : > Does pgadmin have support for dumping and restoring a database? Not yet. The feature request is on the to-do list. http://snake.pgadmin.org/pgadmin3/development.php#todo At present, you have to log on the database server and run pg_dum

[pgadmin-support] RE: [pgadmin-support] Re: How to use the SET data type?  Help plz!

2003-10-27 Thread Dave Page
> -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: 27 October 2003 04:17 > To: [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED] > Subject: [pgadmin-support] Re: How to use the SET data type? > Help plz! > > Odd that it is a selectable datatype in pgadmin then h

[pgadmin-support] Re: How to use the SET data type?  Help plz!

2003-10-27 Thread pgadmin
Odd that it is a selectable datatype in pgadmin then huh? If there are no sets, then is there anythign else that can be used to represent that type of data. I used them a lot in a mySQL database that I am migrating from. It is very useful to have a predefined set of values to choose from, othe