Discussions tagged DB_PostgreSQL
don't connect to my database
Hello, can you help me please?
When I try to connect with my base (open with another device), I see this status with another symbols 'critical error', I don't undarstand the problem. What is it?
Thank you!...
Ivan
In
Connect to Postgre over SSH via command line
Hallo,
in first point - thank you for awesome toll for SQL works!!!
I have short question: I must connect to many different database daily. I want jump direct to SQL editor. I want run some batch/script. I found in documentation that I can create s...
Load Mapping... in Import Wizard unavailable in my paid Single version
I just purchased studio single and i tried the Load Mapping... in the Import Wizard. it fails saying that this feature is available in Pro, Universal, and Single editions. is there anyway to make this feature available in my Single version?
thanks...
Use .pgpass file as source of DB connections
Hi!
Does Valentina Studio has any possibilities to list defined connections of PostgreSQL databases from .pgpass file? Basically it would be very valuable when I could keep configuration for all database connections in one place and just set the t...
B M
In
9.1.4 schema editor performance issues
I have noticed that with very large tables in PostgreSQL 11, studio 9.1.4 takes either a VERY long time to show tables in the schema editor or it does not open them at all and I have to crash studio to recover (Windows). I am talking about tables w...
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...
B M
In
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...
Doru
In
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...
Duane King
In
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....
Pablo Puerto
In
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...
Tony Deifell
In
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