FilesExpand file tree

 master

/

pgsql.sql

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

15 lines (12 loc) · 461 Bytes

 master

/

pgsql.sql

Top

File metadata and controls

• Code
• Blame

15 lines (12 loc) · 461 Bytes

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

1

2

3

4

5

6

7

8

9

10

11

12

13

14

CREATE TABLE users (

id integer,

name character(500),

surname character(1000)

);

INSERT INTO users VALUES (1, 'luther', 'blisset');

INSERT INTO users VALUES (2, 'fluffy', 'bunny');

INSERT INTO users VALUES (3, 'wu', 'ming');

INSERT INTO users VALUES (4, 'sqlmap/1.0-dev (http://sqlmap.org)', 'user agent header');

INSERT INTO users VALUES (5, NULL, 'nameisnull');

CREATE USER testuser WITH PASSWORD 'testpass';

GRANT SELECT ON users TO testuser;