PostgreSQL Snippet List

Snippets are available with TeamSQL Pro Plan.

First item is the label of snippet so you can start writing one of the labels in TeamSQL Query Editor and use them.

 

 

 

SELECT * FROM…

Simple SELECT command

SELECT * FROM with WHERE clause…

Simple SELECT command with WHERE clause

SELECT with INNER JOIN…

SELECT Command with INNER JOIN

INSERT INTO…

Insert into a table on “public”

INSERT INTO with SELECT…

Insert into a table on “public” using SELECT

DELETE FROM…

Delete rows from a table on “public”

UPDATE with WHERE clause…

Update records in a table on “public”

CREATE FUNCTION…

Create a function on “public”

DROP FUNCTION…

Drop a function on “public”

CALL FUNCTION…

Call a function on “public”

CREATE TABLE (Simple)

Create a table on “public”

CREATE TABLE (with Primary Key and index)

Create a table on “public” with primary key and index

DROP TABLE…

Drop a table on “public”

ALTER TABLE…

Alter a table on “public”

SELECT INTO (Structure only)

Create a table (only structure) on “public” like another one

SELECT INTO (Structure & Data)

Create a table (structure & data) on “public” like another one