PostgreSQL

This post is about postgresql commands and other stuffs about it. It will updated when I update it. )

Change PosgreSQL postgres user password

sudo -u postgres psql postgres
postgres=# ALTER USER postgres WITH ENCRYPTED PASSWORD 'a';
ALTER ROLE
postgres=# \q

Create a database with a user that have full rights on the database:

sudo -u postgres createuser -D -A -P myuser
sudo -u postgres createdb -O myuser mydb

Export Database Of Oracle XE 10.x On Ubuntu Linux

oracle@bianca:~$ export ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/
oracle@bianca:~$ /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/exp angelina@bianca

Export: Release 10.2.0.1.0 - Production on Wed Jul 23 04:47:59 2008

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Password:

Connected to: Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production
Enter array fetch buffer size: 4096 >

Export file: expdat.dmp > alectra-dev-20080723.dmp

(1)E(ntire database), (2)U(sers), or (3)T(ables): (2)U >

Export grants (yes/no): yes > no

Export table data (yes/no): yes >

Compress extents (yes/no): yes >

Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses AL32UTF8 character set (possible charset conversion)
Note: grants on tables/views/sequences/roles will not be exported

About to export specified users ...
User to be exported: (RETURN to quit) > alectra

User to be exported: (RETURN to quit) >

. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user ALECTRA
...