How to login into Postgres using terminal in Linux

The default location of postgres in linux is :

/opt/PostgreSQL/8.4/

You can go to this location by typing the below command

> cd /opt/PostgreSQL/8.4/

change to bin directory

> cd bin/

Now for logging into the postgres run following command :

> /opt/PostgreSQL/8.4/bin/psql -U postgres

where 'postgres' is the username that was asked to you while installing the postgres.After this command it will ask you for password. Then enter the password and you are logged in.

Comments

Create Table in Liquibase

For creating table using liquibase you can use below code and add it in your liquibase file. <createTable tableName=“employee”> <column name="id" type="int"> <constraints primaryKey="true" nullable="false"/> </column> <column name="first_name" type="varchar(255)"/> <column name="last_name" type="varchar(255)"/> <column name="username" type="varchar(255)"> <constraints unique="true" nullable="false"/> </column> </createTable> The use is pretty simple it's the way it looks : Tag: <createTable></createTable> This is an opening/ending tag for creating a table. These tags will enclose column sub tags which will define columns for the table. Attribute: tableName : Name of the table which you want to create. (This is a mandatory ...

How databasechangeloglock and databasechangelog table used by liquibase?

Liquibase takes care of executing the query on the database while maintaining the list of queries executed and also maintaining the locks over the tables simultaneously. The two tables that are used by the liquibase for this purpose are : Databasechangeloglock : This table have following columns ID | LOCKED| LOCKGRANTED | LOCKEDBY. This maintains the locks information granted to the user. The primary purpose of this table is to make sure that two machines don't attempt to modify the data at the same time. Databasechangelog : This table have following columns ID | AUTHOR | FILENAME | DATEEXECUTED | ORDEREXECUTED | EXECTYPE | MD5SUM | DESCRIPTION | COMMENTS | TAG | LIQUIBASE This table maintains the list of the statements that are executed on the database.

Carnivorous Island from "Life of PI"

Yann Martel described about an floating carnivorous Island for symbolizing that something seemingly good in life can turn out to be harmful, so we should keep going with our journey of life... About the carnivorous Island from movie. In the movie 'Life of PI' after PI struggles to live in the pacific with the Bengal tiger suddenly one morning Pi found himself at a Island. After spending so many days in the middle of the sea he found himself very lucky to find a Island. After spending some time he thought might be this was the end of his suffering and he can spend rest of his life at that island. He makes h is bed on a tree and sleeps there, in the middle of the night he wakes up and find that there were dead fish in the fresh water where he took swim in the day time. While trying to understand the mystery he plucks a fruit from the same tree and peel it off and finds a human tooth inside that fruit and then he realize that it was an carnivorous Island. The...

Dynamic Views

Search This Blog