Note: command case sensitive. Issued from shell at <install directory>/bin psql -d mydb -U myuser To change database: \c databasename
Category: Database
Running PSQL after first PostgreSQL install on Windows 10
First, make sure Postgresql is running. A way to start the server is by issuing postgres -D ..\data in the
Switching Ofbiz 16.11.04 to Postgresql 9.6 on Windows 10
Follow instruction from Ofbiz technical set up guide. Download 64 bit Postgresql. This download will include a version of pgadmin.
Running Foxpro EXE
Executable built by Visual Foxpro V9 requires 2003 Microsoft Visual C++ Runtime DLL msvcr71.dll. The is problem can be resolved
PHP ODBC Display Columns of a Table
$cnx= odbc_connect(dsn_name,””,””); if( ! $cnx ) { //call error handler //exit } //query column names without content //note, in my
Foxpro Basic Commands
Change default directory: set default to c:\example Edit a program: modify command program name Run a program: do program name
Text and String Handling in VFP
Here’s a good post on text and string handling in Visual Foxpro: http://stevenblack.com/articles/text-and-string-handling-in-VFP/ Note Alines which converts CSV to
Avoiding auto-increment holes on InnoDB with INSERT IGNORE
Short answer: Stop MYSQL server Set innodb_autoinc_lock_mode=0 in my.ini. Note that there are multiple my.ini files in Mysql directories. The
Reset Mysql Root Password Without PHPMyAdmin
Here’s a link to a good post on MYSQL password in general https://www.techrepublic.com/article/how-to-set-change-and-recover-a-mysql-root-password/ First time MYSQL install, use the following
How to upgrade PHPMyAdmin
How to upgrade PHPMyAdmin under XAMPP: Stop MySql Rename the current phpmyadmin directory. Go to https://www.phpmyadmin.net/downloads/ to download the latest version. I