@ThallesComH

do you have any postgres client?

i want to enable pgcrypto plugin, and make tales

no, doing all on vscode

do i need it?

as you already have the railway CLI, let's go with it but from now on I would recommend a postgres client like beekeper, dbeaver or even the psql cli

railway ssh

and then after the connection is established, type psql and hit enter

then just hit any query you want

service name as in, this? shuttle.proxy.rlwy.net ?

or full link

sorry, hit railway link first and then railway ssh

railway link will go through the setup

done

now i type whatever in there?

@ThallesComH

did you hit psql? can you send a screenshot

Project nurturing-peace linked successfully! 🎉 PS C:\Users\kemal\OneDrive\Documents\GitHub\cms\4_rail> npx railway ssh ✓ Connected to interactive shell root@a29cee42a4ba:/#

great then type psql and hit enter

done

now feel free to type any sql query, make sure to end it with ;

okay let me try to put random uuid plugin

railway=# alter table users; alter column user_id set default gen_random_uuid(); ERROR: syntax error at or near ";" LINE 1: alter table users; ^ ERROR: syntax error at or near "column" LINE 1: alter column user_id set default gen_random_uuid();

try a single command at a time

railway=# alter table users; ERROR: syntax error at or near ";" LINE 1: alter table users; ^ railway=# alter table users railway-# ; ERROR: syntax error at or near ";" LINE 2: ;

well the query itself is invalid, it should be like this:

alter table users alter column user_id set default gen_random_uuid();

odd, but it works, thank you

why cant i paste it tho

but i have to rewrite it all

wdym by can't paste and rewrite it all?

i have to write code, cant ctrl + v into cli

if you're on Windows, the CMD paste command is different

iirc it should be the right mouse button

it is

so odd

thank you tho

so i can put in that cli stuff like trigger functions and others?

yep

okay thanks, thats it i think

even tho I would recommend a sql viewer, a lot easier to manage

just installed dbeaver

what I use daily is beekeper as it has a better UI.
but I also keep dbeaver bcs beekeper can be limited in some actions.

can you tell me how can i use dbeaver for this please

it's easy, just add a connection and for credentials refer to your database variables tab

it's all through a GUI

if you've any questions lmk

i pasted URL and said invalid credentias

is all well?

you'll need to fill it out manually, dbeaver for some reason does not accept the DATABASE_URL

like select host and go from there

bruh, alr one sec

done

now, how can i do the cli thing again

i never used these tools, always done it through vscode

nevermind got it lol, thanks again