* O código mencionado acima é somente um exemplo. Caso haja dúvidas quanto sua utilização, sugerimos que verifique juntamente a um desenvolvedor de sua confiança
O Padrão estipulado no servidor é ISO, MDY
Para alterar o formado de data de sua base de dados Postgresql é necessário alterar o DateStyle.
Para Exibir o DateStyle de sua base execute:
SHOW DATESTYLE;
Para Alterar o DateStyle ;
ALTER DATABASE nomedabase SET datestyle TO SQL, DMY;
ou
ALTER DATABASE nomedabase SET datestyle TO ISO, DMY;
Após a alteração acima é necessário logar novamente na base de dados.
Para alterar apenas para a sessão atual:
SET datestyle TO SQL, DMY;
ou
SET datestyle TO ISO, DMY;
Veja também
Versão da base PostgreSQL
Para tal procedimento, você precisa primeiramente estar conectado via SSH. Feito isso, você deve conectar a sua base PostgreSQL usando o comando abaixo:
psql -h HOST -U USUARIODOBANCO -W
A senha do banco de dados será solicitada em seguida.
Ex de utilização do comando:
psql -h postgresql01.meudominio.com.br -U cliente -W
Depois de se conectar ao banco de dados execute o comando a seguir:
SELECT version();
Irá retornar algo como:
version ---------------------------------------------------------------------------------------------------------- PostgreSQL 8.3.6 on x86_64-redhat-linux-gnu, compiled by GCC gcc (GCC) 4.1.2 20071124 (Red Hat 4.1.2-42) (1 row)
Note que a versão da base no caso desse exemplo é PostgreSQL 8.3.6
Veja também
PostgreSQL via SSH
Para tal procedimento, você precisa primeiramente estar conectado a sua hospedagem via SSH. Feito isso, o comando para conexão a sua base PostgreSQL é:
psql -h HOST -U USUARIODOBANCO -W
A senha do banco de dados será solicitada em seguida.
Exemplo de utilização do comando:
psql -h postgresql01.meudominio.com.br -U cliente -W
Também é possível colocar o ip da base ao invés do endereço postgresql01.meudominio.com.br. Veja um exemplo do comando utilizando ip:
psql -h 187.45.196.225 -U cliente -W
Para ver o ip de sua base:
Acesse seu Painel de Controle, informando usuário e senha;
Em Hospedagem de Sites, clique no link Site, da hospedagem desejada, conforme imagem abaixo:
Desça a página até Banco de Dados Compartilhado, clique no ícone do PostgreSQL, como no exemplo abaixo:
Na nova tela que foi aberta, clique no nome da base e verá o campo “IP Servidor:”. O ip da base fica bem na frente desse campo.
Veja também
Hi, Neat post. There’s a problem with your web site in internet explorer, would test this… IE still is the market leader and a huge portion of people will miss your fantastic writing because of this problem.
Hi my friend! I want to say that this article is amazing, nice written and include almost all important infos. I would like to see more posts like this.
Hmm it seems like your site ate my first comment (it was extremely long) so I guess I’ll just sum it up what I wrote and say, I’m thoroughly enjoying your blog. I as well am an aspiring blog blogger but I’m still new to the whole thing. Do you have any recommendations for first-time blog writers? I’d certainly appreciate it.
Well I truly liked studying it. This article offered by you is very practical for good planning.
I know this if off topic but I’m looking into starting my own blog and was curious what all is required to get set up? I’m assuming having a blog like yours would cost a pretty penny? I’m not very web smart so I’m not 100 sure. Any suggestions or advice would be greatly appreciated. Many thanks
My coder is trying to persuade me to move to .net from PHP. I have always disliked the idea because of the expenses. But he’s tryiong none the less. I’ve been using Movable-type on a number of websites for about a year and am nervous about switching to another platform. I have heard excellent things about blogengine.net. Is there a way I can import all my wordpress content into it? Any kind of help would be really appreciated!
Just wish to say your article is as astounding. The clarity on your publish is simply spectacular and that i could assume you are knowledgeable in this subject. Fine along with your permission allow me to clutch your feed to stay up to date with coming near near post. Thank you 1,000,000 and please keep up the gratifying work.
I was wondering if you ever considered changing the layout of your blog? Its very well written; I love what youve got to say. But maybe you could a little more in the way of content so people could connect with it better. Youve got an awful lot of text for only having 1 or two pictures. Maybe you could space it out better?
You completed a number of nice points there. I did a search on the issue and found nearly all people will have the same opinion with your blog.betflik
I discovered your blog web site on google and test a couple of of your early posts. Proceed to keep up the excellent operate. I just extra up your RSS feed to my MSN Information Reader. In search of forward to studying more from you later on!…
I’m not that much of a online reader to be honest but your sites really nice, keep it up! I’ll go ahead and bookmark your site to come back in the future. Cheers
Hiya, I’m really glad I have found this information. Nowadays bloggers publish just about gossips and net and this is actually irritating. A good web site with exciting content, that is what I need. Thanks for keeping this web-site, I will be visiting it. Do you do newsletters? Cant find it.
You completed a number of nice points there. I did a search on the issue and found nearly all people will have the same opinion with your blog.betflik