Discussions tagged DB_PostgreSQL

Importing JSONB Data from CSV to PostGres?

I would like to import data to a jsonb field from a csv. I've tried things like: "stripes":true, "solids":true "stripes:true", "solids:true" {"stripes":true, "solids":true} ...etc., but I get an error when trying to import to a jsonb fiel...

Data transfer issues in Studio Pro 9.1

There is something strange going on with data transfer in Studio Pro. First some background: 1. Source db: Postgres 11 2. Target db: Postgres 10 The Postgres version should make no difference as we are talking about a simply table mapping. P...

Connection to Azure PosgreSQL is it supported?

I downloaded Valentina Studio and it seems that I cannot connect to the Azure PosgreSQL. The user and db name in the connection are different than the default ones and I cannot change them. Is Azure PosgreSQL supported? I looked over the forums an...

Unable to Change Relationship Cardinality

Hello all, I'm using Valentina Studio 8.7.2 on Mac OS 10.14.2 with Postgres 9.4 running on Ubuntu 16.0.4. On an existing database, I need to change some table relationships from one-to-many to one-to-one, but when I attempt to modify the cardi...

Undock SQL Editor window

Hello, I am trying to find a good multi-platform alternative to the old good PgAdmin3 because I don't like the new web interface of PgAdmin4. I tried Valentina Studio and I like the interface and the features it has but I badly miss something a...

How do I support the UUID type in my DB so that when I export its used as the correct type in postgresql?

I am trying to use the PostgreSQL uuid type in my database, and I notice that despite wide support for it and the actual intention for me to use it in my end database, its missing from the type list in the pulldown menu. I'm not sure what to do as at...

What are the available Command Line Parameters for Valentina Studio ?

Hello. I'm using Valentina Studio and I was wondering what were the command line parameters to open it already connected to a particular server/database. And why not, directly open a SQL Editor Window on it. It is the last thing missing for us t...

Import bookmarks to 6.0.3

I move the discussion (frome Facebook) on import bookmarks from version 5.8.1 to 6.0.3. I hope that soon manage to solve this problem....

Scrolling problem with schema editor in tree mode

It's better to show the problem than explain it. [img]http://www.imagebam.com/image/2aa696393704450[/img] [img]http://www.imagebam.com/image/656970393704451[/img] [img]http://www.imagebam.com/image/3202f0393704452[/img] Valentina Studio Free ...

How do you view constraints?

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 th...

permission denied for database

Hi. On our heroku app logs, i'm seeing the following error, but I am able to access the database in Valetina Studio. Why am I getting this error and is there anything I can do about it? 2015-01-13T01:41:55Z app[postgres.15012]: [JADE] permission d...
  • Page :
  • 1

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. 0 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories
Omegabundle
  1. 0 subcategories