Question : I’m trying to write a quick line in bash that will use psql to connect to a database […]
Tag: command-line
How can I unload Oracle database tables into a csv files?
Question : I need to retrieve certain data from an Oracle 11g release 1 database and provide it as one […]
Batch for PostgreSQL query
Question : 1) The pgpass.conf (of PostgreSQL) is: localhost:5432:*:postgres:mypassword I have no experience with batch and I have spent the […]
Pg install: “The database cluster initialisation failed”
Question : (Note: This question has been compeltely rewritten from its original form, so it reflects the actual problem and […]
How do I force windows to use a specific version of SQLCMD?
Question : I have several versions of SSMS installed on my machine. We have legacy servers running several versions of […]
MySQL Error: Data Too Long For Column CHAR(5) – MariaDB 10.3.10 [closed]
Question : Closed. This question is off-topic. It is not currently accepting answers. Too localized – this could be because […]
How do I test if MySQL “require secure transport” is working?
Question : I activated the checkbox named “require secure transport” in the options file, found in the MySQL Workbench. How […]
How to load data from another sql file into a main sql file? – MYSQL
Question : I am trying to process the scripts dbcreate_f.sql and dbload_f.sql to create and to load data into a […]
How can I ONLY get the query execution time on the command line without waiting till the data is displayed?
Question : I am testing and comparing execution times of queries with big result sets using the command line. It […]
How can I detect the use of SQL Server replication on a server (all versions) preferably using PS or CMD
Question : I am trying to find a way to detect if a customer has SQL Server replication on. This […]