Skip to content
How to update all field in Word (Windows and Mac OS)

Quick answer: To update many Word fields in the main document, press Ctrl+A followed by F9 in desktop Word for Windows. This updates selected fields, including many cross-references and tables of contents, but may not cover fields in headers, footers, text boxes or other document stories. This guide explains how to update fields reliably, why some fields are skipped, and what to check before distributing a long document. Different ways… Read More »Update All Fields in Word: TOC, Captions and Cross-References

Update All Fields in Word: TOC, Captions and Cross-References

Three ways to insert degree symbol in Mac OS

Quick answer: On many Mac keyboard layouts, press Option+Shift+8 to insert the degree sign °. You can also open the macOS Character Viewer using Control+Command+Space (or the Emoji & Symbols menu) and search for “degree.” How to type the degree symbol on a Mac Method 1: Use Character Viewer (Emoji & Symbols) In an app that offers it, choose Edit > Emoji & Symbols to open symbol and emoji search… Read More »How to Type the Degree Symbol (°) on Mac

How to Type the Degree Symbol (°) on Mac

Creating table in postgresql

Quick answer: Use PostgreSQL’s CREATE TABLE statement to define a new table, its columns, data types and constraints. Example: CREATE TABLE employees (employee_id integer PRIMARY KEY, full_name text NOT NULL, hired_on date);. CREATE TABLE creates a relation in a schema and a corresponding composite row type. The name must not conflict with another relation in that schema, and the composite type name must also be available. Schema-qualified names such as… Read More »CREATE TABLE in PostgreSQL: Syntax, Constraints and Examples

CREATE TABLE in PostgreSQL: Syntax, Constraints and Examples

Header only on first page

Quick answer: Open the header, enable Different First Page, and put the desired content in the first-page header. Leave the regular header blank so later pages do not repeat it. Steps to Insert Header Only on First Page The following method works in Word for Microsoft 365, Word for Microsoft 365 for Mac, Word for the web Word 2019, Word 2019 for Mac, Word 2016, Word 2013, Word 2010, Word 2016 for Mac. 1) Navigate to the first… Read More »How to Show a Header Only on the First Page in Word

How to Show a Header Only on the First Page in Word

add column in existing table

Quick answer: Use ALTER TABLE employees ADD COLUMN phone text; to add a PostgreSQL column. To add several, use ALTER TABLE employees ADD COLUMN phone text, ADD COLUMN active boolean DEFAULT true;. Syntax Replace table_name, column_name and data_type with your actual identifiers and type. The DEFAULT clause is optional. PostgreSQL uses ADD COLUMN, not ADD COLUMN_NAME; COLUMN may be omitted, but including it is clearer. Refer the below example for… Read More »Add Columns in PostgreSQL with ALTER TABLE: Syntax and Examples

Add Columns in PostgreSQL with ALTER TABLE: Syntax and Examples

Quick answer: PostgreSQL is a free, open-source object-relational database with SQL, transactions, JSONB, extensible indexing and a mature ecosystem. Its historical DBMS-of-the-Year awards describe changes in an external popularity index—not proof that it is the fastest database for every workload. This article explains the 2017, 2018 and 2020 recognition in historical context, then shows where PostgreSQL is useful, what its trade-offs are, and how to evaluate it for a real… Read More »PostgreSQL: DBMS of the Year Recognition and Key Features

PostgreSQL: DBMS of the Year Recognition and Key Features

How to draw circle in Word and PowerPoint

Quick answer: Choose Insert → Shapes → Oval and hold Shift while dragging to draw a circle. For exact dimensions, set the same Height and Width under Shape Format. Draw a Perfect Circle in Word or PowerPoint Open Insert > Shapes and choose Oval (under Basic Shapes). Click and drag on the page or slide. Hold Shift while dragging to constrain the oval to a circle. Release the mouse button… Read More »How to Draw a Perfect Circle in Word or PowerPoint

How to Draw a Perfect Circle in Word or PowerPoint