Monday, October 26, 2009

ko nyoah command yang beda jo MYSQL

COMMAND POSTGRES| Result

\d

\dt : List all tables

\di : List all indexes

\ds : List all sequences

\dv : List all views

\dS : List all PostgreSQL-defined tables

\d table-name : Show table definition

\d index-name : Show index definition

\d view-name : Show view definition

\d sequence-name: Show sequence definition

\dp : List all privileges

\dl : List all large objects

\da : List all aggregates

\df : List all functions

\df function-name: List all functions with given name

\do : List all operators

\do operator-name: List all operators with given name

\dT : List all types

\l : List all databases in this cluster

No comments: