Search
 
SCRIPT & CODE EXAMPLE
 

SQL

how to connect postgres user password using command line

sudo -u postgres psql postgres
Comment

psql connect as user with password

# "-W" will prompt for the password
psql -h <host-ip> -d <database-name> -U <username> -W
Comment

how to connect postgres user password using command line

password postgres
Comment

Login to psql database as another user

psql -d database -U username
Comment

PREVIOUS NEXT
Code Example
Sql :: truncate statement in sql 
Sql :: wherein mysql 
Sql :: phone number sql 
Sql :: mysql query bulk insert 
Sql :: check if sql temp table exists 
Sql :: sqlalchemy left join 
Sql :: mysql query first character 
Sql :: sql server query all database objects 
Sql :: mssql disable foreign key constraint 
Sql :: sql unique rows 
Sql :: get server date mysql 
Sql :: create table in mysql 
Sql :: mysql database manager 
Sql :: create pl/sql stored procedure 
Sql :: select last 2 characters sql 
Sql :: oracle sql create table from select 
Sql :: oracle insert into 
Sql :: postgres set column equal to another 
Sql :: postgresql casting integer to string 
Sql :: datediff in sql server 
Sql :: how to login sql server using cmd 
Sql :: sql function 
Sql :: mysql show all table from database 
Sql :: mysql set last_insert_id 
Sql :: select last 30 days sql 
Sql :: windows services sql 
Sql :: sql count number of rows after group by 
Sql :: mysql delete duplicate rows but keep one 
Sql :: install mysql on ubuntu 
Sql :: oracle sql drop column if exists 
ADD CONTENT
Topic
Content
Source link
Name
3+5 =