View Attach Info

Add new attachment

Only authorized users are allowed to upload new attachments.

This page (revision-9) was last changed on 02-May-2021 10:21 by BlakeMcBride

This page was created on 02-May-2011 21:13 by UnknownAuthor

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Difference between version and

At line 1 changed one line
!psql
!psql - command line database query tool
At line 7 changed one line
to see all output:
to save all output:
At line 18 added one line
\d table display schema for table
At line 24 added 7 lines
show all;
show server_version;
show config_file;
show data_directory;
show hba_file;
}}}
{{{
At line 35 added one line
! Data Types
At line 37 added 23 lines
| smallint | 2
| integer | 4
| bigint | 8
| real | 4
| double precision | 8
| smallserial | 2
| serial | 4
| bigserial | 8
| money | 8
| char(n) |
| varchar(n) |
| text | variable length, unlimited
| bytea | binary, variable length
| timestamp | date and time | not null default current_timestamp
| date |
---------------------------------------------------------------------------
! Passing a password into psql
{{{export PGPASSWORD=ThePassword}}}
---------------------------------------------------------------------------
At line 31 changed one line
psql arahant postgres -c 'select screen_id, substring(filename from 24) as "File Name", name from screen order by filename;' >output.txt
psql mydb postgres -c 'select screen_id, substring(filename from 24) as "File Name", name from screen order by filename;' >output.txt
psql mydb postgres -f file-name >output.txt
Version Date Modified Size Author Changes ... Change note
9 02-May-2021 10:21 6.14 kB BlakeMcBride to previous
8 13-Jul-2016 14:35 5.677 kB BlakeMcBride to previous | to last
7 20-Jun-2016 12:45 5.527 kB BlakeMcBride to previous | to last
6 15-Feb-2016 14:21 5.485 kB BlakeMcBride to previous | to last
5 10-Jul-2014 10:04 5.487 kB BlakeMcBride to previous | to last
4 18-Dec-2013 20:52 5.452 kB BlakeMcBride to previous | to last
3 17-Nov-2013 19:08 5.352 kB BlakeMcBride to previous | to last
2 24-Jul-2013 15:47 4.97 kB BlakeMcBride to previous | to last
1 02-May-2011 21:13 4.546 kB UnknownAuthor to last
« This page (revision-9) was last changed on 02-May-2021 10:21 by BlakeMcBride