nvl (oracle) equivalent in postgres

Move a table to other schema in Postgres

ALTER TABLE table_name SET SCHEMA new_sc

sql postgresql

kishore_kumar

Drop table in Sql

Drop table Table_name;

sql mysql

sonia shaik

how to print star using sql

DECLARE @var int               
SELECT @var = 5 
WHILE @var >0

sql printing pattern my sql

sonia shaik

decode (oracle) equivale in postgres

Simple Case:
case search-expression
    WHEN expression [, expression [ ... 

sql postgres oracle

sonia shaik

PostgreSQL CONCAT_WS function

SELECT
   concat_ws (column1,column2) AS new_co
FROM

sql concat_ws

Reshma

Adding a new auto increment column to a table

-- New versions of postgres
-- adding as primary key

sql postgres postgresql

kishore_kumar

How to dump a database in postgresql

sudo -i -u postgres

psql

dump postgresql sql

Reshma