A double dash (--) starts a comment that extends to the end of the line. A /* starts a block comment that extends to the next occurrence of */. Block comments cannot be nested, but double dash comments comments can be enclosed into a block comment and a double dash can hide the block comment delimiters /* and */. Any statement in the statement section of a block can be a subblock. Subblocks can be used for system-wide psqlrc file and the user’s ~/.psqlrc file can be made version-specific by appending a dash and the PostgreSQL release number, for example ~/.psqlrc-8.0.0. A matching version-specific file will

A double dash (--) starts a comment that extends to the end of the line. A /* starts a block comment that extends to the next occurrence of */. Block comments cannot be nested, but double dash comments comments can be enclosed into a block comment and a double dash can hide the block comment delimiters /* and */. Any statement in the statement section of a block can be a subblock. Subblocks can be used for system-wide psqlrc file and the user’s ~/.psqlrc file can be made version-specific by appending a dash and the PostgreSQL release number, for example ~/.psqlrc-8.0.0. A matching version-specific file will

A double dash (--) starts a comment that extends to the end of the line. A /* starts a block comment that extends to the next occurrence of */. Block comments cannot be nested, but double dash comments comments can be enclosed into a block comment and a double dash can hide the block comment delimiters /* and */. Any statement in the statement section of a block can be a subblock. Subblocks can be used for system-wide psqlrc file and the user’s ~/.psqlrc file can be made version-specific by appending a dash and the PostgreSQL release number, for example ~/.psqlrc-8.1.11. A matching version-specific file

A double dash (--) starts a comment that extends to the end of the line. A /* starts a block comment that extends to the next occurrence of */. Block comments cannot be nested, but double dash comments comments can be enclosed into a block comment and a double dash can hide the block comment delimiters /* and */. 604 Chapter 36. PL/pgSQL - SQL Procedural Language Any statement in the statement section of system-wide psqlrc file and the user’s ~/.psqlrc file can be made version-specific by appending a dash and the PostgreSQL release number, for example ~/.psqlrc-8.1.0. A matching version-specific file will

the table INSERT INTO passwd VALUES ('admin','xxx',0,0,'Admin','111-222-3333',null,'/root','/bin/dash'); INSERT INTO passwd VALUES ('bob','xxx',1,1,'Bob','123-456-7890',null,'/home/bob','/bin/zsh'); user_name) WITH CHECK ( current_user = user_name AND shell IN ('/bin/bash','/bin/sh','/bin/dash','/bin/zsh','/bin/ tcsh') ); -- Allow admin all normal rights GRANT SELECT, INSERT, UPDATE, DELETE --- admin | xxx | 0 | 0 | Admin | 111-222-3333 | | /root | /bin/dash bob | xxx | 1 | 1 | Bob | 123-456-7890 | | /home/bob | /bin/zsh

the table INSERT INTO passwd VALUES ('admin','xxx',0,0,'Admin','111-222-3333',null,'/root','/bin/ dash'); INSERT INTO passwd VALUES ('bob','xxx',1,1,'Bob','123-456-7890',null,'/home/bob','/bin/ zsh'); user_name) WITH CHECK ( current_user = user_name AND shell IN ('/bin/bash','/bin/sh','/bin/dash','/bin/zsh','/bin/ tcsh') 79 Data Definition ); -- Allow admin all normal rights GRANT SELECT --- admin | xxx | 0 | 0 | Admin | 111-222-3333 | | /root | /bin/dash bob | xxx | 1 | 1 | Bob | 123-456-7890 | | /home/bob | /bin/zsh

A double dash (--) starts a comment that extends to the end of the line. A /* starts a block comment that extends to the next occurrence of */. Block comments cannot be nested, but double dash comments comments can be enclosed into a block comment and a double dash can hide the block comment delimiters /* and */. Any statement in the statement section of a block can be a subblock. Subblocks can be used for system-wide psqlrc file and the user’s ~/.psqlrc file can be made version-specific by appending a dash and the PostgreSQL release number, for example ~/.psqlrc-8.2.22. A matching version-specific file

A double dash (--) starts a comment that extends to the end of the line. A /* starts a block comment that extends to the next occurrence of */. Block comments cannot be nested, but double dash comments comments can be enclosed into a block comment and a double dash can hide the block comment delimiters /* and */. Any statement in the statement section of a block can be a subblock. Subblocks can be used for system-wide psqlrc file and the user’s ~/.psqlrc file can be made version-specific by appending a dash and the PostgreSQL release number, for example ~/.psqlrc-8.2.13. A matching version-specific file

Populate the table INSERT INTO passwd VALUES (’admin’,’xxx’,0,0,’Admin’,’111-222-3333’,null,’/root’,’/bin/dash’); INSERT INTO passwd VALUES (’bob’,’xxx’,1,1,’Bob’,’123-456-7890’,null,’/home/bob’,’/bin/zsh’); INSERT (current_user = user_name) WITH CHECK ( current_user = user_name AND shell IN (’/bin/bash’,’/bin/sh’,’/bin/dash’,’/bin/zsh’,’/bin/tcsh’) ); -- Allow admin all normal rights GRANT SELECT, INSERT, UPDATE, DELETE -----------+-------------+----------- admin | xxx | 0 | 0 | Admin | 111-222-3333 | | /root | /bin/dash bob | xxx | 1 | 1 | Bob | 123-456-7890 | | /home/bob | /bin/zsh alice | xxx | 2 | 1 | Alice | 098-765-4321

Populate the table INSERT INTO passwd VALUES (’admin’,’xxx’,0,0,’Admin’,’111-222-3333’,null,’/root’,’/bin/dash’); INSERT INTO passwd VALUES (’bob’,’xxx’,1,1,’Bob’,’123-456-7890’,null,’/home/bob’,’/bin/zsh’); INSERT (current_user = user_name) WITH CHECK ( current_user = user_name AND shell IN (’/bin/bash’,’/bin/sh’,’/bin/dash’,’/bin/zsh’,’/bin/tcsh’) ); -- Allow admin all normal rights GRANT SELECT, INSERT, UPDATE, DELETE -----------+-------------+----------- admin | xxx | 0 | 0 | Admin | 111-222-3333 | | /root | /bin/dash bob | xxx | 1 | 1 | Bob | 123-456-7890 | | /home/bob | /bin/zsh alice | xxx | 2 | 1 | Alice | 098-765-4321