PostgreSQL Commands

I am definitely not a DBA but I can Google. Recently at work I broke out production instance of Sal. How I’m still not sure but was able to get Sal working but the Key’s for the groups were different. I had several different options but the easiest I thought was to just update the Key field in the database and call it good. Below are my basic notes.

psql -U USERNAME DATABASE

\l – List databases

\c database

\dt – listing tables

select * from TABLE – show data on table. (After selecting the database)

update TABLE set FIELD = ‘VALUE’ where ID = #;

Enjoy

Post Tagged with , , , ,