Difference between revisions of ".sql"

From wikieduonline
Jump to navigation Jump to search
(Created page with " -- Create extensions CREATE EXTENSION IF NOT EXISTS "uuid-ossp"; -- -- Create Users -- -- Passwords should be random generated with 40 alphanumeric chars fo...")
 
Line 3: Line 3:
 
  -- Create extensions
 
  -- Create extensions
 
  [[CREATE EXTENSION IF NOT EXISTS]] "[[uuid-ossp]]";
 
  [[CREATE EXTENSION IF NOT EXISTS]] "[[uuid-ossp]]";
 
+
 
  --
 
  --
 
  -- Create Users
 
  -- Create Users
Line 10: Line 10:
 
  -- Passwords should be random generated with 40 alphanumeric chars for each environment and stored in the correct vaults.
 
  -- Passwords should be random generated with 40 alphanumeric chars for each environment and stored in the correct vaults.
 
  [[CREATE USER]] xxxx WITH PASSWORD 'xxxxxx';
 
  [[CREATE USER]] xxxx WITH PASSWORD 'xxxxxx';
 
+
 
+
 
  --
 
  --
 
  -- Create Database and Schema
 
  -- Create Database and Schema
Line 18: Line 18:
 
  \c XXXXX
 
  \c XXXXX
 
  [[CREATE SCHEMA]] yyyyy;
 
  [[CREATE SCHEMA]] yyyyy;
 +
 +
{{SQL}}

Revision as of 08:07, 18 July 2024


-- Create extensions
CREATE EXTENSION IF NOT EXISTS "uuid-ossp";

--
-- Create Users
--

-- Passwords should be random generated with 40 alphanumeric chars for each environment and stored in the correct vaults.
CREATE USER xxxx WITH PASSWORD 'xxxxxx';


--
-- Create Database and Schema
--

\c XXXXX
CREATE SCHEMA yyyyy;

SQL, NewSQL, RDMS: GraphQL (2015), SQLite, select, insert, select count, Distributed SQL, TablePlus, Cache hit ratio, pg_stat_user_tables, EXPLAIN, Index (PostgreSQL), DDL, SQL/MED, Group by, List users, SQL Injection, SQLAlchemy, CREATE USER, CREATE ROLE, EXPLAIN, ALTER DATABASE, REVOKE, NOLOCK, NOWAIT, EXISTS, Unique constraint, .sql

Advertising: