PostgreSQL Table 32 codes

  1. Home
  2. PostgreSQL
  3. Table
1 Add a column
2 Add a new column with check option
3 Adds a comment to the customers table
4 Adds a text column
5 ALTER TABLE books RENAME COLUMN
6 ALTER TABLE employee ADD COLUMN description text
7 ALTER TABLE employee DROP COLUMN city CASCADE
8 Altering column defaults
9 Changing a Columns Data Type
10 Changing table ownership
11 Copies data from a system file into the publishers table
12 Copy the employees table to the emp_table file
13 Copying an ASCII file to data table
14 Copying the books table to an ASCII file
15 Create a new table by specifying the table name, along with all column names and their types
16 Create a temporary table
17 Creates a backup table
18 Creating the books table
19 Drop a table
20 Drop table cascade
21 Grants all privileges on a table to the user manager
22 Insert value to composite column
23 Reference column name through table name
24 Reference column type through column type
25 Removing a Column
26 Rename a column
27 Rename the employees table to personnel
28 Renaming a Column
29 Renaming a table
30 To access a field of a composite column
31 TRUNCATE TABLE employee
32 Use d to display table information