PostgreSQL CONCAT_WS function

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

nvl (oracle) equivalent in postgres

COALESCE(value [, ...])
The COALESCE function accepts an unlimit
It returns the first argument that is no

sql postgres oracle

sonia shaik

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