Skip to main content

PostgreSQL on the command line

I am just getting back into PostgreSQL.  Here are the things I had to learn today:

1.  Command line usage:
  • su - postgres
  • psql
  • select version();
2.  Dumping data for import on another server
  • pg_dump -o mydb -U postgres -W > mydb.sql
  • -o has to do with oids (Not sure if I need this yet)
  • -U is for user
  • -W is for password.  It prompts when you run the command


Labels:

Comments

Post a Comment

Popular posts from this blog

How to get ProxyPass to ignore a URL so you can still use Apache HTACCESS

On a few of my servers I use Apache with Apache Tomcat. and ProxyPass to forward requests from apache over to Tomcat for my Coldfusion pages. The part I have been struggling with for so long was how to do password protected directories in apache.  Either by adding the config to the VirtualHost directive or by .htaccess. It seemed no matter what I did, requests were getting proxied and there was nothing I could do about it. Tonight I finally found my answer: The ProxyPass !  combo: ProxyPass /dealers/ ! Here is the whole apache configuration I use for connecting Apache to Tomcat and URL Rewriting: I found this mentioned on a  Sitepoint Post
1 comment
Read more

UPS - User Id and Shipper Number combination is not qualified to receive negotiated rates.

Today I started to receive the following message from the UPS API: User Id and Shipper Number combination is not qualified to receive negotiated rates. and to make matters worse, the result of this issue caused the checkout process to error preventing our customers from finishing their orders. So after doing a little research on my end I ended up calling the UPS technical support phone number for the United States: Over the phone we went over the following steps: UPS.COM You must add and authenticate your account using Account Summary to view Negotiated Rates in UPS Internet Shipping, Time and Cost Calculator on ups.com, and the UPS Developer Kit - Shipping and Rating APIs. To add and authenticate an account: 1. Login to ups.com using your My UPS ID and password. 2. Select the My UPS tab at the top of the page. 3. Select Account Summary from the navigation menu or the tab rollover. 4. From there select Add an Existing UPS Account. 5. Follow the steps to authenticate the account. To aut
Post a Comment
Read more

Boy I wish there was a way to create a table from a select query

I was doing some SQL work today when I had a thought: Boy I wish there was a way to create a table from a select query I started in Navicat to see if it was possible.  After find nothing I decided to google it all the while thinking in my head how I was going to create a script to do this if I couldn't find anything. I found something. I was happy yet sad.  Happy because I didn't have to take the time to create something.  Sad because I didn't have to create the tool.  It sounded like a fun project. What did I find you ask? The "Create Table as" statement. CREATE TABLE [ IF NOT EXISTS ] new_table [ AS ] SELECT expressions FROM existing_tables [WHERE conditions]; The best part about it is the statement knows to go to the existing tables to get the column type, size etc.   Such a tremendous time saver.  I cannot believe in all my years of programming I never stumbled upon this type of statement. Source: Tech on the Net
Post a Comment
Read more