Coastal's Blog

On here you'll find tips and notes on stuff i'm interested in. That's normally xbmc, movie libraries, psp homebrew and gadgets. I'll also post some code examples which are more for my reference than anything else.

Wednesday, 19 September 2012

Show databases and tables in postgresql


show databases:
select datname from pg_database;
show tables:
\dt
Posted by Unknown at 08:33

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Blog Archive

  • ►  2013 (4)
    • ►  December (2)
    • ►  July (1)
    • ►  January (1)
  • ▼  2012 (10)
    • ▼  September (6)
      • postgresql replication, load balancing and SPOFs
      • Show databases and tables in postgresql
      • postgres ssh-copy-id: ERROR: No identities found
      • Cluster your PostGIS
      • Loading PostGIS with ESRI Shapefiles
      • How to get an up-to-date OSM in PostGIS
    • ►  August (1)
    • ►  March (2)
    • ►  January (1)
  • ►  2011 (7)
    • ►  September (1)
    • ►  July (1)
    • ►  June (1)
    • ►  May (1)
    • ►  February (1)
    • ►  January (2)
  • ►  2010 (13)
    • ►  November (1)
    • ►  May (1)
    • ►  February (2)
    • ►  January (9)
  • ►  2009 (18)
    • ►  December (1)
    • ►  November (1)
    • ►  October (1)
    • ►  September (1)
    • ►  August (1)
    • ►  July (4)
    • ►  May (2)
    • ►  April (1)
    • ►  February (4)
    • ►  January (2)
  • ►  2008 (24)
    • ►  December (1)
    • ►  November (1)
    • ►  October (2)
    • ►  September (4)
    • ►  August (1)
    • ►  June (1)
    • ►  April (2)
    • ►  March (10)
    • ►  January (2)
  • ►  2007 (9)
    • ►  December (1)
    • ►  October (8)

About Me

Unknown
View my complete profile
Simple theme. Powered by Blogger.