Migracija sa MySQL-a na PostgreSQL
From RCUB
m (→Konfigurisanje servera) |
(dodata tabela mysql -> psql komandi) |
||
| Line 81: | Line 81: | ||
GRANT ALL ON SCHEMA public TO username; | GRANT ALL ON SCHEMA public TO username; | ||
| + | |||
| + | ===Kratka myslq -> psql tabela=== | ||
| + | {| class="wikitable" border="1" | ||
| + | |- | ||
| + | ! MySQL <code>mysql</code> | ||
| + | ! PostgreSQL <code>psql</code> | ||
| + | |- | ||
| + | | <code>SHOW COLUMNS;</code> | ||
| + | | <code>\d ''table-name''</code> | ||
| + | |- | ||
| + | | <code>SHOW DATABASES;</code> | ||
| + | | <code>\l</code> | ||
| + | |- | ||
| + | | <code>SHOW PROCESSLIST;</code> | ||
| + | | <code>SELECT * FROM pg_stat_activity;</code> | ||
| + | |- | ||
| + | | <code>SHOW TABLES;</code> | ||
| + | | <code>\d</code> | ||
| + | |- | ||
| + | | <code>SHOW USERS;</code> | ||
| + | | <code>\du</code> | ||
| + | |- | ||
| + | | <code>USE ''db-name'';</code> | ||
| + | | <code>\c ''db-name''</code> | ||
| + | |} | ||
| + | <ref>http://trac.biostr.washington.edu/trac/wiki/PostgreSql</ref> | ||
==Konfigurisanje servera== | ==Konfigurisanje servera== | ||
| Line 98: | Line 124: | ||
pg_ctl reload | pg_ctl reload | ||
| + | |||
| + | ==Spoljašne veze== | ||
| + | * [http://trac.biostr.washington.edu/trac/wiki/PostgreSql lista psql komandi] | ||
