The words Under construction in black text on a yellow background with diagonal black stipes surrounding it
I'm in the process of moving my site. It's still a work in progress. Please excuse the mess and broken links.

Connect to Postgres Databases With psql

TODO: Pull subtitle into page object

The default way to connect to post gres is:

code_start_default_section code_end_default_section

Debugging Stuff

I'm moving stuff around right now. All this below is helping me figure out where to put stuff

        -- title

Connect to Postgres Databases With psql

-- p

The default way to connect to post gres is:

-- code/

psql postgres

-- /code

-- p

which connects to the postgres database as the current user
you're runnig on the command line

-- p

To connect to a specific database as a specific user (aka role), use:

-- code/

psql -U user_name -d database_name

-- /code

-- p

To connect to the root database with the root user, do this:

-- code/

psql -U postgres

-- /code


-- categories
-- Miscellaneous

-- metadata
-- date: 2021-11-25 22:03:50
-- id: 21rf88em
-- status: scratch
-- type: post
-- SCRUBBED_NEO: false
-- site: aws