1. Daniel Hartless
  2. Valentina Studio
  3. 木, 2月 05 2015, 06:10 AM
  4.  メールで購読
In PgAdmin3, you can view the constraints on a table. For example, the _pkey constraint Postgres adds for primary keys. Is there a way to view this in valentina studio? I can see indexes, relations (foreign constraints) and uniques but can't find the constraints.

Thanks!
Alan
コメント
There are no comments made yet.
Ruslan Zasukhin 承諾済みの回答
Hi Daniel,

soon should arrive VStudio guys, meanwhile I have connect to some postgreSQL db, and I also see: Checks, Indexes, Unuques, FKs,

Primary Key field is marked with a KEY icon in the Fields area.

So I wonder what exactly constraints you want to see? And why?

Do you want to see all constraints together under some section "Constraints"?
コメント
There are no comments made yet.
Sergey Pashkov 承諾済みの回答
Hi Daniel,

Right, a Primary Key is managed on the Fields tab of Design Table dialog.
コメント
There are no comments made yet.
Daniel Hartless 承諾済みの回答
The big thing is I needed to see the name of the constraint as I was doing something programmatically that needed to know it. Relatively new to postgres so didn't realize that it created a constraint when a primary key is created that I had to deal with separately unlike mysql where it is just an index.

pgadmin3 showed it to me under contraints: http://cl.ly/image/1V3h3L1r322R
valentina studio just showed me there was a primary key http://cl.ly/image/3G2V1l3k1E1q

Thanks!
Alan
コメント
There are no comments made yet.
Ruslan Zasukhin 承諾済みの回答
Well, I think always it is possible to use some SQL command to see that constraints in raw form.

Sergey, what you think if there is sense add folder Constraints also under Schema?
but then this should be raw format ... just list ...
We can also allow 'remove' command for such list.

But what about 'create new' ?
コメント
There are no comments made yet.
  • ページ :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.

Categories

Announcements & News
  1. 0 subcategories
Valentina Studio
  1. 2 subcategories
Valentina Server
  1. 4 subcategories
Valentina Database ADK
  1. 0 subcategories
Valentina Reports ADK
  1. 0 subcategories
Other Discussions
  1. 2 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories