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
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(
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
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
> -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
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