ALTER TABLE table_name RENAME TO new_table_name Code language: SQL (Structured Query Language) (sql)ĭrop a table and its dependent objects: DROP TABLE table_name CASCADE Code language: SQL (Structured Query Language) (sql) Managing viewsĬreate a view: CREATE OR REPLACE view_name AS query Code language: SQL (Structured Query Language) (sql)Ĭreate a recursive view: CREATE RECURSIVE VIEW view_name(column_list) AS SELECT column_list Code language: SQL (Structured Query Language) (sql)Ĭreate a materialized view: CREATE MATERIALIZED VIEW view_nameĪS query WITH DATA Code language: SQL (Structured Query Language) (sql) ALTER TABLE table_nameĭROP CONSTRAINT primary_key_constraint_name Code language: SQL (Structured Query Language) (sql) ALTER TABLE table_name ADD PRIMARY KEY (column.) Set or remove a default value for a column: ALTER TABLE table_name ALTER COLUMN Code language: SQL (Structured Query Language) (sql)Īdd a primary key to a table. Rename a column: ALTER TABLE table_name RENAME column_name TO new_column_name Code language: SQL (Structured Query Language) (sql) ) Code language: SQL (Structured Query Language) (sql)Īdd a new column to a table: ALTER TABLE table_name ADD COLUMN new_column_name TYPE Code language: SQL (Structured Query Language) (sql)ĭrop a column in a table: ALTER TABLE table_name DROP COLUMN column_name Code language: SQL (Structured Query Language) (sql) Show query output in the pretty-format: \xĬreate a new role: CREATE ROLE role_name Ĭreate a new role with a username and password: CREATE ROLE username NOINHERIT LOGIN PASSWORD password Ĭhange role for the current session to the new_role: SET ROLE new_role Īllow role_1 to set its role as role_2: GRANT role_2 TO role_1 Code language: SQL (Structured Query Language) (sql) Managing databasesĬreate a new database: CREATE DATABASE db_name Code language: SQL (Structured Query Language) (sql)ĭelete a database permanently: DROP DATABASE db_name Code language: SQL (Structured Query Language) (sql) Managing tablesĬreate a new table or a temporary table CREATE TABLE table_name( Show a stored procedure or function code: \df+ function_name Or to get more information on tables in the current database: \dt+ List all views: \dv Code language: SQL (Structured Query Language) (sql) List all stored procedures and functions: \df List all schemas: \dn Code language: SQL (Structured Query Language) (sql) List all databases in the PostgreSQL database server \l
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |