Search
 
SCRIPT & CODE EXAMPLE
 

SQL

creating postgresSQL database using the the shell

$ createdb mydb
Comment

connecting to a new database using postgresql sql shell

For Windows users using the SQL shell

c DB_NAME USER_NAME HOST PORT

// to get the connection details such as your username, host and port simply use the "conninfo" command

eg : c test1 john_doe localhost 5432
Comment
PREVIOUS NEXT
Code Example
Sql :: android sqlite add column if not exists 
Sql :: adding constraints to columns SQL 
Sql :: how to check if a column is null in sql 
Sql :: mariadb json select 
Sql :: mysql export database command line 
Sql :: sql now 
Sql :: oracle sql concatenate results into string 
Sql :: mysql backup database 
Sql :: oracle apex debug time 
Sql :: sql select case when 
Sql :: spring boot working with sql database connection 
Sql :: join multiple tables sql 
Sql :: mysql declare variable 
Sql :: oracle index hint 
Sql :: How to drop procedures in mysql ? 
Sql :: mysqlclient error 
Sql :: oracle index size calculation 
Sql :: row to json in sql server 
Sql :: change data type in mysql 
Sql :: drop CHECK constraint sql 
Sql :: mysql: command not found 
Sql :: postgres week number 
Sql :: replace text in sql 
Sql :: sql find second highest salary employee 
Sql :: restore backup mysql .gz 
Sql :: mysql how to use FIND_IN_SET function in WHERE clause ? 
Sql :: to_date postgresql 
Sql :: how to print sql query 
Sql :: ORA-01090: shutdown in progress - connection is not permitted 
Sql :: postgres create database if not exists 
ADD CONTENT
Topic
Content
Source link
Name
9+8 =