sql
List of commands for sql:
-
mysql:migrate:postgress Migrate from MySQL Database to PostgresSQL Database$ pgloader mysql://${mysql_username}:${mysql_password}@${mysql_hostname}:${mysql_port}/${mysql_database_name} postgresql://${postgres_username}:${postgres_password}@${postgres_hostname}:${postgres_port}/${postgres_database_name}try on your machineexplain this command
-
postgresql:export:csv Store result of a PostgreSQL query as a CSV file$ psql -d dbname -t -A -F"," -c "${query}" > ${file_name}try on your machineexplain this command
-
postgresql:import:sql Import SQL dump into a PostgreSQL database$ psql ${database_name} < ${database_dump}try on your machineexplain this command
-
sql:warp:25557 Export SQLite query to a CSV file$ sqlite3 -header -csv ${db_filepath} ${sql_query} > ${output_filepath}try on your machineexplain this command
-
sql:warp:2944c Execute a .sql file against a PostgreSQL database$ psql -U ${user_name} -d ${database_name} -a -f ${file_name}try on your machineexplain this command
-
sql:warp:b962f Dump a MySQL database into a file$ mysqldump -u ${user_name} -p ${db_name} > ${file_name}try on your machineexplain this command
-
sql:warp:f6d09 Create a copy of a PostgreSQL database$ createdb -O ${owner_name} -T ${original_db} ${new_db}try on your machineexplain this command