Question : One of the things I need to do on my job is run lines of SQL code. I […]
Tag: command-line
Mysql 5.1.X How to upload data from dump file without the partitioning commands?
Question : I need to upload data from a dump file (large one) that includes partitioning info into a database […]
Is there a psql equivalent of bash’s reverse-search-history?
Question : I am very fond of bash‘s reverse-search-history (C-r) (command-line feature): Search backward starting at the current line and […]
Can’t insert arabic text into mysql database using mysql prompt
Question : I had a local table with arabic values.when exported i got the following query. DROP TABLE IF EXISTS […]
How do I list all databases and tables using psql?
Question : I am trying to learn PostgreSQL administration and have started learning how to use the psql command line […]
connect to psql and run SQL command from command line
Question : I’m trying to write a quick line in bash that will use psql to connect to a database […]
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 […]