Highlight the word or paragraph that you need to convert to Capitals/Uppercase Click on the menu Format and then on Font A new Window will appear with the Font tab open Under the Effects section check the checkbox next to All Caps Click on OK and the selection of words/paragraphs will be converted to uppercase
How to copy a columns data from one table into a column in another table using PostgreSQL? Eg. name columns data from the users table into name****column in the new_users table. Execute the query below with different column names and table names and all the data for a specific column will be copied over to the selected column in another table. INSERT INTO n_owners(owner_name) SELECT owner_name FROM owners;
If you need to copy data from one table (table_a) into another table (table_b) using pgsql. There are 2 methods on how to do this. Method 1 NOTE: If you are using this method table_b should not yet exist. If you want an exact duplicate without indexing or relying on objects use this. SELECT * INTO table_b FROM table_a Method 2 NOTE: This method will work if table_b already exist. ...
SCP = SECURE COPY (remote file copy program), with SCP you can copy files over an SSH connection securely and encrypted. With this Linux command line toolyou can copy files remotely from one remote server to another, or from you’re PC to a remote server. USAGE = scp [-1246BCpqrv] [-c cipher] [-F ssh_config] [-i identity_file] [-l limit] [-o ssh_option] [-P port] [-S program] [[user@]host1:]file1 … [[user@]host2:]file2 OPTIONS = Open a terminal window on you’re Linux box, or/and type in the command line the following command for all options for scp: man scp EXAMPLE = scp DevServer**.test.lan:/var/www/html/testSite/images/image1.jpg****testserver:/var/www/html/images/NewImages** ...
This can be done using the Google AdWords Editor. The first step is to download and install the Google AdWords Editor. Download by clicking here. Once installed run the Google AdWords Editor application. Once opened, click on the Account top menu item and then **Open ** Right click on the selected account and click on Open NOTE: _You might first need to sign in to your Google AdWords account via the **Google Adwords Editor ...
How to create a backup of a PostgreSQL database to a sql file? This sql file then can be used to restore the database on a later stage. Follow the steps below in order to create a backup Open a Terminal Window if not yet in command line Login as user postgres. eg. sudo su postgres Type in the following command pg_dump db_name -CdiOv > /tmp/db_name_backup.sql pg_dump = Utility to backup a PostgreSQL db. -C = Begin the output with a command to create the database itself and reconnect to the created database. -d = Dump the data as INSERT commands -i = Ignores version mismatch between the old database server and the new database server. -O = No owner, the database does not belong to any specific owner that was specified in the database -v = Verbose, will output a detailed report of pg_dump if ran in command line. > /tmp/db_name_backup.sql = dump the output of the command into a file called db_name_backup.sql (Here you may choose any location on your drive where you want the backup to be stored) Now you have a backup of your pqsl database in sql file format NOTE: PostgreSQL 8.3.7 has been used and installed on Ubuntu 9.04 with this how-to ...
What is a symbolic link? A symbolic link is a special file that points to another file on the system. When you access one of these files, it has a pathname stored inside it. Use this pathname to advance to the file or directory on the system represented by the pathname stored in the symbolic link. How to create a symbolic link? Create a symbolic link with the ln command with the -s option ...
Open a new Terminal Window Type in the following command dd if=/dev/sr0 of=myISO.iso Explanation dd = covert and copy a file if = read from FILE instrad of stdin /dev/sr0 = This is your cd-rom device, please remember to replace this with your device of = write to FILE instead of stdout myISO.iso = The location and filename where you want the ISO file saved
This can be accomplished by using the dropdb and createdb command line wrappers The syntax to create a new database on the command line is createdb [ options ] dbname Example: createdb -O user new_database - E UTF8 This will create a new database called new_database and assign the user user to it and use the encoding UTF8 To drop a database on the command line the syntax dropdb [ options ] dbname is used. ...
Use the following statement ALTER TABLE my_table DROP COLUMN my_column; Replace my_table with the your table name and my_column with the column that you need to drop/remove.