🛢️
PostgreSQL
Ctrlk
Grokking Algorithm
  • Content
  • Environment
  • Getting Started
  • Basic
    • Querying Data
    • Filtering Data
    • Joining Multiple tables
    • Grouping data
    • Set Operations
    • Grouping sets, Cube, and Rollup
    • Subquery
    • Common Table Expressions
    • Modifying Data
    • Transactions
    • Import & Export Data
    • Managing Tables
      • Data types
      • Create a table
      • Select into
      • Create table as
      • Auto-increment
      • Sequences
      • Identity column
      • Alter table
      • Rename table
      • Add column
      • Drop column
      • Change column data type
      • Rename column
      • Drop table
      • Truncate table
      • Temporary table
      • Copy a table
    • Understanding PostgreSQL constraints
    • PostgreSQL Data Types in Depth
  • Advanced
  • PG-PGSQL
  • Functions
  • Adminstration
  • API
Powered by GitBook
On this page

Was this helpful?

  1. Basic

Managing Tables

Data typesCreate a tableSelect intoCreate table asAuto-incrementSequencesIdentity columnAlter tableRename tableAdd columnDrop columnChange column data typeRename columnDrop tableTruncate tableTemporary tableCopy a table
PreviousExport PostgreSQL Table to CSV fileNextData types

Last updated 1 year ago

Was this helpful?