I'm rather new to Postgres and Navicat is the only fully functional GUI that I've come across. That said, I'm trying to implement a simple auto increment for an id. Navicat doesn't seem to support ...

I've encountered into a connection issue between PostgreSQL 15 and Navicat 15. My environment is: Windows 10 PostgreSQL 15 Navicat Premium 15.0.16 (Activated) How to produce: Open 'New Connectio...

I am running a local server of MySQL 5.6.10 on MacOS 10.8.3 and manage my database via Navicat essentials for MySQL. The error I get is that after running and managing my database just fine for a c...

I have bunch of tables where several of them have hundreds of columns. I need to get a count of non-null values for each column and I've been doing it manually. I would like to figure out a way to ...

I have a column in my CSV file that contains a string of numbers separated by commas. Excel keeps converting them to numbers even though I want to treat it as text. Example: 470,1680 get converte...

hoping this is a pretty straightforward question. I have a straightforward SELECT query (with a few sub-queries built in). I have over 40 DBs and I need to run this query for all DBs (all have sam...

I have a sqlite database and I want to connect from my C# program using a password for the database. I am using Navicat and I set encrypt database file with password "test" and then by code my conn...

I try to use navicat on mac os Big Sur but whene I put password get this error! Failed to save password Error code: -34018 Other apps work correctly!

I currently have a query merging two tables to create a new one for analysis. After getting some funny results when trying to chart it for presentation, I learned that some of it is fake data that ...

I try to connect with my database and use Navicat with MacOS , but I get an error and not able to connect. I tried many different things but not able to connect yet. any help really appreciates and...

I am trying to connect to a MySQL server hosted by strato. I am connecting to the DB using PuTTy as instructed on this page. Now connecting to my database is no problem if I am using the terminal:...

is there a way to install Navicat on Ubuntu 14.04 without using wine? just straight up from deb or apt-get install.. I tried installing it using wine, but the problem is it does not function well e...

As the screenshots show, I have the accounts setup to allow remote connections but as shown in the second screenshot I still cannot connect remotely.

In Navicat, how do I enclose a selection in a comment? Is there a keyboard shortcut for this action?

I'm trying to send an email to several recipients when a new row is inserted into a table. The list of recipients varies. I would like to be able to set this list using a select statement. I also ...

in navicat you can arrange the order of the columns but i have yet to find a way to sync the changes with the database. i saw a similar question here -> Rearrange column order in Sqlyog but haven't...

How do you save a postgresql query output as a table? Similar to the maketable query within Access. I want to be able to join other tables to the query output and making a new table would make life...

In the following stored procedure I encountered an error: DROP PROCEDURE IF EXISTS `SP_DeleteFileInfo`; CREATE PROCEDURE `SP_DeleteFileInfo`(pFileID int) Set @FileRef= null; select filesinfo.Refe...

Often when I define a View in Navicat I receive the following message: xxx does not have a primary key. Updates to this table will be done using the following pseudo statement: UPDATE xxx SET Mo...