Create Database:
Createdb is a program(command) that executes from the shell to create new databases.
Example: createdb edbstore
Example: createdb edbstore
- Create Database command can be used to create a database in a cluster.
Syntax:
Creating Databases
CREATE DATABASE name [ [ WITH ] [ OWNER [=] dbowner][ TEMPLATE [=] template ][ ENCODING [=] encoding ][ TABLESPACE [=] tablespace][ CONNECTION LIMIT [=] connlimit ] ]
Creating Databases
CREATE DATABASE name [ [ WITH ] [ OWNER [=] dbowner][ TEMPLATE [=] template ][ ENCODING [=] encoding ][ TABLESPACE [=] tablespace][ CONNECTION LIMIT [=] connlimit ] ]
Access Database:
The psqltool allows you to interactively enter, edit, and execute SQL commands.
The PEM Client tool can also be used to access a database.
To use psql to access a database:
The PEM Client tool can also be used to access a database.
To use psql to access a database:
-Open the command prompt or terminal.
-If PATH is not set you can execute next command from the bin directory location of postgresinstallation
-If PATH is not set you can execute next command from the bin directory location of postgresinstallation
-$psql–U postgresedbstore
-edbstore=#
-edbstore=#
also see below
No comments:
Post a Comment