Your feedback is highly appreciated! Let's make Vertabelo even better.

+2

Adding columns: batch add and paste

Nicholas Hohman 9 years ago 0

Be able to add X number of columns instead of one at a time. Then, can also paste them in if they're on the clipboard, one NBSP per time (e.g. from Excel, etc.).

+1

When importing, give option to add to existing model or new one

Nicholas Hohman 9 years ago 0

When you're on the model and import SQL, it overwrites whatevers in the model with what's imported from the SQL file. It would be neat if it added or gave you the option to overwrite model vs. add.

0
Answered

INT type for Year value throws Warning message

Marvin Abarca 9 years ago updated by Rafał Strzaliński (Senior Engineer) 9 years ago 2

Don't know why this is happening, I would like to create a column with the year value for example 2016,2015, 2014 etc... however the Table Problems is showing Warning

Image 292

0
Not a bug

vertabelo community

ahmed mohamed 9 years ago updated by Adam Mościcki 9 years ago 2

when i try to access the Catalog of database models by Vertabelo's community i get 404

did you remove it ?

Answer
Adam Mościcki 9 years ago

Hello,


This feature is unavailable right now, but we are going to restore it. I will keep you posted.

0

error in documentation: postgres sequences - nextval()

Josef Steppan 9 years ago updated 9 years ago 0

Hi,


just a minor error in one of your documentation pages:

http://www.vertabelo.com/documentation/database-model-elements/sequences


nextval(sequence_name) should be nextval('sequence_name') :


for reference:

http://www.postgresql.org/docs/current/static/functions-sequence.html



Also, thanks for providing such a great service, helped me a lot with my relational databases course :-)

+1
Started

Database type of model copy defaults to PostgreSQL

Adam Stojanowski 9 years ago updated by Adam Mościcki 9 years ago 2

I made a copy of DB2 model using "Make a copy" option in right-click menu on Documents screen.

Result: Copy defaulted to PostgreSQL db type.


Tested also for Oracle - same effect, db type of copy is PostgreSQL.

0

provide an option to add relation (the diamond shaped box)..which can be changed to a table with a click .Useful in case of many to many relationships

sravani singirikonda 9 years ago updated 9 years ago 0

provide an option to add relation (the diamond shaped box)..which can be changed to a table with a click .Useful in case of many to many relationships.

Also an option to show the kind of relation is useful(like many to many ,one to one ,many to one)

0

Foreign key order in the output SQL file

Michał Majcher 9 years ago 0

Foreign key DDL commands in the SQL output file from Vertabelo are ordered by constraint name. It would be more useful if they were ordered by table name first and later by constraint name or even better by referenced table name.


Current solution results in an unpleasant diff on the SQL file.

+1
Answered

how to specify schema for a reference ?

Ali Tabrizi 9 years ago updated by Rafał Strzaliński (Senior Engineer) 9 years ago 6

In SQL Model , please note that we are using 5 different schema in our model so we will need to specify each reference `s schema

0
Answered

How to install Vertabelo Client on Ubuntu server 14.04 ?

PRODHOMME Sébastien 9 years ago updated by Rafał Strzaliński (Senior Engineer) 9 years ago 3

I read this article https://my.vertabelo.com/db-connection to install Vertabelo Client. I download the Linux File but it hasn't a type format for this file like .deb or others. I tried to use dpkg command but it doesn't work.

Answer
anonymous 9 years ago

It's a binary file. You need to chmod +x and just run it.