skip to main
|
skip to sidebar
Learning by Doing
catatan seorang office boy
Home
Islamic
Java
Linux
Community
Ubuntu Metro
KPLI Jakarta
KPLI Padang
About Me
Friday, December 30, 2011
Show Table Name and Primary key on postgresl
Untuk mengetahui table name dan primary key saja dalam postgresql querynya seperti berikut
SELECT table_name, column_name, ordinal_position FROM information_schema.key_column_usage ;
sample outputnya :
0 komentar:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
dendy
Blog ku Sebagai memory kDUO,untuk mengingatkan ku disaat lupa.
View my complete profile
Translate
Labels
Applications
BIG FAMILY
Campur Sari
CINTA SEJATI
Data WareHouse
Eclipse
Gawean
google code
Hibernate
Islamic
IT World
Java
Kawan Sma
Kemenyan
KPLI Jakarta
Linux
Mysql
Oracle
payakumbuah
Pendidikan
PostgreSQL
puisi
RCP n RAP
Solaris
SQL n Database
svn
Tips and Trik
Ubuntu
Ubuntu Metro
Blog Archive
Blog Archive
August (32)
September (8)
October (39)
November (15)
December (31)
January (21)
February (13)
March (14)
April (17)
May (20)
July (9)
August (4)
September (7)
October (9)
November (13)
December (5)
January (3)
February (7)
March (8)
April (4)
June (16)
July (9)
September (4)
October (1)
December (4)
January (2)
February (2)
Feedjit Live Blog Stats
Free Blogger Templates
by
FREE7 BLOGGER (tapi sebagian dendy yang edit :D )
0 komentar:
Post a Comment