![]() Run a CREATE DATABASE command to create a new database. In the Windows Command Prompt, run the command: psql -U userName If the directory path is not added to the PATH variable, you must specify the psql.exe file path in the Command Prompt to start psql. All rights reserved.This step enables you to use the command psql to start the PostgreSQL command-line tool (psql) from the Windows Command Prompt. If this clause is omitted the password will be valid for all time.Ĭopyright (C) 2005. This clause sets an absolute time after which the user's password is no longer valid. This is normally not necessary, but may be useful if you need to recreate the owner of an orphaned object. The SYSID clause can be used to choose the PostgreSQL user ID of the new user. This option also turns the user into a superuser who can override all access restrictions.Ĭontrol whether the password is stored encrypted in the system catalogs. If TRUE, the user is allowed to create new users. If TRUE, the user is allowed to create databases. Only superusers may create tablespaces, but they can assign ownership of tablespaces to non-superusers.ĭefines a user's ability to create databases. If omitted, defaults to the user executing the command. The name of the user who will own the tablespace. ![]() The directory must be specified by an absolute path name. The directory that will be used for the tablespace. Temporary tables are automatically dropped at the end of a session, or optionally at the end of the current transaction. If specified, the table is created as a temporary table. True means the constraint is INITIALLY DEFERRED, it is checked only at the end of the transaction. If a constraint is deferrable, this clause specifies the default time to check the constraint.įalse means the constraint is INITIALLY IMMEDIATE, it is checked after each statement. All other constraint types are not deferrable. Only foreign key constraints currently accept this clause. Checking of constraints that are deferrable may be postponed until the end of the transaction. A constraint that is not deferrable will be checked immediately after every command. This controls whether the constraint can be deferred. (See also extended attribute type ProcLanguageList.) May be SQL, C, internal, or the name of a user-defined procedural language. The name of the language that the function is implemented in. The following extended attributes are available on the Language tab: Name This is normally not necessary, but may be useful if you need to recreate a group referenced in the permissions of some object. ![]() The SYSID clause can be used to choose the PostgreSQL group ID of the new group. A stand-alone composite type is useful as the argument or return type of a function. This is essentially the same as the row type of a table, but using CREATE TYPE avoids the need to create an actual table when all that is wanted is to define a type. The composite type is specified by a list of attribute names and data types. The following extended attributes are available on the Composite Type tab: Name Name of a function, created by CREATE FUNCTION, which converts data of this type into a form suitable for transmission to another machine. Name of a function, created by CREATE FUNCTION, which converts data of this type from a form suitable for transmission from another machine to internal form. Indicates that operators and functions which use this data type should be passed an argument by value rather than by reference. Name of a function, created by CREATE FUNCTION, which converts data from its internal form to a form suitable for display. Literal value which specifies the internal length of the new type. ![]() Name of a function, created by CREATE FUNCTION, which converts data from its external form to the internal form of the type. Specifies the type of the array elements. The following extended attributes are available on the Base Type tab: Name Specify a string constant (e.g., 'SQL_ASCII'), or an integer encoding number, or DEFAULT to use the default encoding. The name of the template from which to create the new database, or DEFAULT to use the default template.Ĭharacter set encoding to use in the new database. The following extended attributes are available on the PostgreSQL tab: Name ![]() The following extended attributes are defined by default in the PostgreSQL DBMS. PowerDesigner 12.0 > PowerDesigner PDM User's Guide > DBMS-Specific Features > PostgreSQL ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |